Question: - Create a table that list the OrderID, CustID and CustName from Orders table using LEFT JOIN with Customers table on CustID.' - Write SQL
- Create a table that list the OrderID, CustID and CustName from Orders table using LEFT JOIN with Customers table on CustID.'
- Write SQL statement to list the OrderID, CustName and OrderDate from Orders table using INNER JOIN with Customers table on CustID.

Consider the following tables. Orders table OrderID CustID Order Date 101 22 2018-09-18 102 12 2020-09-19 103 32 2020-09-20 Customers table CustID 12 22 34 CustName Lim Heng Kong Ali Ahmed Daniel Lee ContactName Country John Woo Singapore Elon Mask Malaysia David Cooper Korea
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
