Menachem,
> SUM(check_applications.namountapplied IF checks.lvoid=0)
Close. Try SUM(IF(checks.lvoid=0,0,check_applications.namountapplied))
PB
-
Menachem Bazian wrote:
Hi,
I was wondering if anyone can help me with this syntax. I have three
tables, INVOICES, CHECKS and CHECK_APPLICATIO
Hi,
I was wondering if anyone can help me with this syntax. I have three
tables, INVOICES, CHECKS and CHECK_APPLICATIONS. I need to SUM the
amounts in CHECK_APPLICATIONS for each invoice IF the check it is
related to has not been voided. Something like this (in SQL and pseudocode)
SELECT inv
