Question

Discuss the "Inner and outer join" commands with suitable example.

Answer 1

Inner join limits the quarry work.

For example, you have two rows in the first table and 3 in the other, the final result will have six consequences in total. Where as the outer joint will find all results from two or more rows in the same or different table irrespective of them. Ex, if the phone number is null in any conclusion, it will still show.