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.