Query with not in subquery

Hello!

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)

In this case you should use SQL expression:

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.