Sunday 6 October 2013

13. Write a query to display the sales order IDs of the orders received from the Northeast territory.

select salesOrderID from sales.salesOrderHeader
where territoryID=(select TerritoryID
from sales.salesTerritory
Where Name='Nottheast')

No comments:

Post a Comment