SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode FROM Customer_T WHERE Customer_T.CustomerlD = (SELECT Order_T.CustomerID FROM Order_T WHERE OrderlID = 1008);

What are the name and address of the customer who placed order number
1008?

SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState,<br>CustomerPostalCode<br>FROM Customer_T<br>WHERE Customer_T.CustomerlD =<br>(SELECT Order_T.CustomerID<br>FROM Order_T<br>WHERE OrderlID = 1008);<br>

Extracted text: SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode FROM Customer_T WHERE Customer_T.CustomerlD = (SELECT Order_T.CustomerID FROM Order_T WHERE OrderlID = 1008);

Jun 08, 2022

SOLUTION.PDF

SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode FROM Customer_T WHERE Customer_T.CustomerlD = (SELECT Order_T.CustomerID FROM Order_T WHERE OrderlID = 1008);

Get Answer To This Question

Related Questions & Answers

Submit New Assignment