Forum

Hello, I hope everyone is good and healthy. I have goods catalog and each item has a tabular section. How can I create a query where this tabular section is empty?

I think I found the answer. I used IN operator and I prepared the list items and I compared them.

WHERE
   NOT ListItem.Ref IN Ref

Ref = [Item1,Item2,Item3....] => I fill the list with another query where the list items in.

You can use LEFT JOIN on ref with tabular section table and IS NULL check in WHERE