SQL JOINS

SQL CROSS JOIN returns every possible combination of rows from the every table being joined(This is also called Cartesian product).

Here is how SQL EXCEPTION JOIN works. It returns rows from PRIMARY table that don’t have a match in any of SECONDARY table. Columns that come from SECONDARY table(s) will always have null value.

SQL OUTER Join gives All data from PRIMARY table with matching date from SECONDARY table(s) appended to it. If no matching data found in SECONDARY table(s) for join condition NULL value will be used to fill that space.

INNER Join returns records which are common in all tables based on given join condition. There are two ways to write INNER Join:[SAMPLE DATA]

SQL JOINS allow you to combine records for multiple tables based on some condition. This condition in most cases is “common value(s)” between tables needed to join. But there are options of more conditions. If you have worked on DB2 JOIN LOGICAL FILE it has almost same concept as SQL JOINS but SQL JOINS give you more options [...]