{"id":487,"date":"2024-08-30T01:29:54","date_gmt":"2024-08-30T01:29:54","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=487"},"modified":"2025-06-01T13:15:09","modified_gmt":"2025-06-01T13:15:09","slug":"full-outer-join","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/full-outer-join\/","title":{"rendered":"FULL OUTER JOIN"},"content":{"rendered":"\n

SQL FULL OUTER JOIN Keyword<\/h2>\n\n\n\n

The FULL OUTER JOIN keyword returns all records when there is a match in either the left or the right table. Records without a match in either table will still appear in the result, with NULL values where applicable.<\/p>\n\n\n\n

<\/p>\n\n\n\n

SQL FULL OUTER JOIN Syntax<\/h2>\n\n\n\n
SELECT table1.column1, table2.column2\nFROM table1\nFULL OUTER JOIN table2\nON table1.common_column = table2.common_column;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL FULL OUTER JOIN Example<\/h2>\n\n\n\n
This SQL statement selects all patients and all appointments, even when there’s no match between them:<\/p>\n\n\n\n
SELECT Patients.first_name, Appointments.appointment_date\nFROM Patients\nFULL OUTER JOIN Appointments\nON Patients.patient_id = Appointments.patient_id;<\/pre><\/div>\n\n\n\n
\n
Note:<\/strong> This example does not<\/strong> work in SQLite or in our TechKubo playground because FULL OUTER JOIN<\/code> is not supported in SQLite. Use only in MySQL, PostgreSQL, SQL Server, or Oracle.<\/p>\n<\/blockquote>\n\n\n\n
<\/p>\n\n\n\n
SQL FULL OUTER JOIN Labs<\/h2>\n\n\n\n