8.6. FULL OUTER JOIN

 

  • The FULL OUTER JOIN keyword return all records when there is a match in either left (table1) or right (table2) table records.

Note: FULL OUTER JOIN can potentially return very large result-sets.


Image of full join


QUERY: - SELECT T1.column_name, T2.column_name FROM table1 T1 FULL JOIN table1 T2 on condition;

EXAMPLE: - SELECT a.e_id, a.f_name, b.salary FROM employee a FULL JOIN salary b on a.e_id = b.e_id;

Last modified: Monday, 2 December 2019, 12:19 PM