Join Functions - FULL OUTER JOIN

 FULL OUTER JOIN: Mengembalikan semua rekod apabila terdapat padanan dalam rekod jadual kiri (jadual1) atau kanan (jadual2)

Sintaks:

SELECT column_name FROM table1

LEFT JOIN table2

ON table1.column_name=table2.column_name

UNION

SELECT column_name FROM table1

RIGHT JOIN table2

ON table1.column_name=table2.column_name;