I have a table of orders and I have a table of packingslips...
the packingslips contain a foregin key linking to the orders table.
I want to return all the orders that are not linked to a packingslip.
I tried this...but it just returns all the orders...
select orders.id from orders
left outer join packingslips on orders.id = packingslips.orderid