Sunday 6 October 2013

04. Write a query to display the sales order ID, the product ID, and the order date for all the products in the following format.







select 'Order ID'=  h.salesOrderID,
'Product ID'= d.productID,
'Order Date'= OrderDate
from sales.salesOrderHeader h
join sales.salesOrderDetail d
on h.salesOrderID= d.salesOrderID

No comments:

Post a Comment