how to use the SQL Server FULL OUTER JOIN to query data from two or more tables.
Mercy Margret Answered question
The syntax of the SQL FULL OUTER JOIN statement is:
- SELECT columns FROM table1 FULL OUTER JOIN table2 ON table1. column1 = table2. column2;
- SELECT Customers. customer_id, Customers.
- SELECT Customers. customer_id, Customers.
- — use alias C for Categories table — use alias P for Products table SELECT C. category_name, P.
Shathana. S.R. Answered question