ms access - Compare value of rows SUM in SQL query

Question

I would like to select the rows where OutgoingInvoice.TPP field not equals the SUM of Products.IncomingSUM where the OutgoingInvoice.ID = Products.OutgoingInvoice

I wrote this SQL query:

SELECT j.* FROM OutgoingInvoice AS j WHERE (((j.TPP)<>(select sum (jj.IncomingSUM) from Products as jj where jj.OutgoingInvoice = j.ID ) ));

It do not shows any rows, but there are some. What do I wrong?

question from:https://stackoverflow.com/questions/65545738/compare-value-of-rows-sum-in-sql-query

Answer 1

You could try using WHERE NOT EXISTS instead of <>

 SELECT j.* FROM OutgoingInvoice AS j 
 WHERE NOT EXISTS(((j.TPP) = (select sum (jj.IncomingSUM) from Products as jj where jj.OutgoingInvoice = j.ID ) ));