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: [image] Filtering data with two many valued associations TMS Aurelius In this case you should use SQL expressions , using, for example, EXISTS clause . Pseudo-code: Find<TAnagrFiscale> .Where(Linq.Sql('Exists SELECT * FROM Anagr…

Query with not in subquery

BIZ TMS Aurelius

wlandgraf (Wagner Landgraf) June 21, 2024, 7:33pm 2

In this case you should use SQL expression:

1 Like

Topic		Replies	Views
Select queries with subquery TMS Aurelius	1	505	September 10, 2013
Filter depending on association TMS Aurelius	2	472	February 12, 2020
not contains TMS Aurelius	2	282	December 2, 2021
Fetching details rows with projection TMS Aurelius	3	149	February 2, 2024
How can I fetch entities that has not been saved into another table? TMS Aurelius	3	53	September 5, 2025

Query with not in subquery

Related topics