Community & Support Portal

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...

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...

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 ...

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 NUL...

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...

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 ...