I need to delete all order records that do not container order items.
the tables are linked by the orderId on the orderItems table. So i can do the following
select * from orders o
inner join orderitems oi on o.id = oi.orderid
How can i detect which order records contain no child orderItems