============================== TABLE [Customers] ( ============================== [CustomerID] [CompanyName] [ContactName] [ContactTitle] [Address] [City] [Region] [PostalCode] [Country] [Phone] [Fax] CONSTRAINT [PK_Customers] PRIMARY KEY CLUSTERED ( [CustomerID] ) ON [PRIMARY] ================================== TABLE Employee =================================== EmployeeID LastName FirstName Title TitleOfCourtesy BirthDate HireDate Address City Region PostalCode Country HomePhone Extension Photo Notes ReportsTo PhotoPath Table Order ======================== 3 OrderID 0 CustomerID 0 EmployeeID 0 OrderDate 0 RequiredDate 0 ShippedDate 0 ShipVia 0 Freight 0 ShipName 0 ShipAddress 0 ShipCity 0 ShipRegion 0 ShipPostalCode 0 ShipCountry SELECT dbo.Customers.CompanyName, dbo.Employees.LastName, dbo.Employees.FirstName, dbo.Orders.OrderDate, dbo.Orders.RequiredDate FROM dbo.Orders INNER JOIN dbo.Customers ON dbo.Orders.CustomerID = dbo.Customers.CustomerID INNER JOIN dbo.Employees ON dbo.Orders.EmployeeID = dbo.Employees.EmployeeID Rami Abd Alhalim