-
SQL – Full Outer Join
SQL Full Outer Join Table Of Contents: What Is SQL Outer Join? Syntax Of SQL Outer Join. Examples Of SQL Outer Join. (1) What Is SQL Outer Join? The FULL OUTER JOIN keyword returns all records when there is a match in left (table1) or right (table2) table records. FULL OUTER JOIN and FULL JOIN are the same. (2) Syntax Of SQL Outer Join? Syntax: SELECT column_name(s) FROM table1 FULL OUTER JOIN table2 ON table1.column_name = table2.column_name WHERE condition; (3) Examples Of SQL Outer Join? Customer: Orders: Example-1: SELECT Customers.CustomerName, Orders.OrderID FROM Customers FULL OUTER JOIN Orders ON Customers.CustomerID=Orders.CustomerID ORDER BY Customers.CustomerName; Note: The FULL OUTER
