Basics of JOINs

INNER JOIN
An INNER JOIN returns all the common rows between both of the tables (Table A and Table B). As per the below example, the JOIN selects all the Items and th...
Tue, 6 Oct, 2020 at 4:39 PM
LEFT OUTER JOIN
A LEFT OUTER JOIN returns all rows from the left table (Table A) with the matching rows from the right table (Table B) or NULL – if there is no match in the...
Tue, 6 Oct, 2020 at 4:58 PM
RIGHT JOIN
A RIGHT OUTER JOIN returns all the rows from the right table (TableB) with the matching rows from the left table (TableA) or NULL – if there is no match in ...
Tue, 6 Oct, 2020 at 5:49 PM
FULL JOIN
FULL   JOIN returns matched and unmatched rows from both tables (it's a union of both). If there is no match, the missing values will be inserted as NU...
Tue, 6 Oct, 2020 at 5:49 PM
SELF JOIN
A Self join is a join in which it is joined with the table itself based on the condition.  For e.g. The below employee table contains the details such as E...
Tue, 6 Oct, 2020 at 8:57 PM
CROSS JOIN / CARTESIAN JOIN
A CROSS JOIN is a Cartesian product of Table A and Table B. Every row from Table A is matched with every row from Table B. As per the below example, every ...
Tue, 6 Oct, 2020 at 8:58 PM