Question: write these 3 SQL question use join methods 1.List matching orders (OrderID) and all customers (Company Name). 2.List all employees (names and IDs only) and
write these 3 SQL question use join methods
1.List matching orders (OrderID) and all customers (Company Name).
2.List all employees (names and IDs only) and their corresponding managers (names only).
3.List all orders (OrderID) and matching customers (Company Name).

1 dbo.CustomerCustomerDemo dbo.CustomerDemographics dbo.Categories dbo.Customers 1 o CustomerlD (PK, nchar(5), not null) CompanyName (nvarchar(40), not null) ContactName (nvarchar(30), null) C ontacttle (nvarchar (30), null) E Address (nvarchar(60), null) City (nvarchar(15), null) Region (nvarchar(15), null) PostalCode (nvarchar(10), null) Country (nvarchar(15), null) Phone (nvarchar(24), null) Fax (nvarchar(24), null) 1 1 dboEmployees E dbo.EmployeeTerritories E dboOrder Details dboOrders El dboProducts dboRegion dboShippers dbo.Suppliers
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
