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