how to use the SQL Server FULL OUTER JOIN to query data from two or more tables.
Mercy Margret Answered question
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.
Vishalini.R Answered question