How do I create a query that returns rows that do not include certain field from a subquery? For example return all invoices that do not have a certain invoice item. SQL example (meta SQL):
SELECT *
FROM doc_headers
WHERE id NOT IN (SELECT HEADER_ID FROM doc_items WHERE PRODUCT_ID=3)