Skip to main content
edited tags
Link
Derek F
  • 64.1k
  • 15
  • 55
  • 104
Source Link
knay
  • 37
  • 5

How to only select orders, where orders contain orderitems

I have this query but it is returning orders where there a no orderitems present, how can i only select orders that have order items in them?

SELECT EffectiveDate, Description, id, (select order.id from orderitems) FROM Order