The SQL FULL OUTER JOIN statement has the following syntax:
column1 = column2; SELECT Customers. customer_id, Customers. SELECT columns FROM table1 FULL OUTER JOIN table2 ON table1.
customer_id, Customers, and SELECT Customers…
— for the Categories table, use alias C — for the Products table, use alias P category_name, P. from SELECT C.

Example syntax to select from multiple tables:

1. SELECT p. p_id, p.cus_id, p.p_name, c1.name1, c2.name2.
2. FROM product AS p.
3. LEFT JOIN customer1 AS c1.
4. ON p.cus_id=c1.cus_id.
5. LEFT JOIN customer2 AS c2.
6. ON p.cus_id = c2.cus_id.