Last post Feb 27, 2019 05:58 PM by mgebhard
Feb 27, 2019 05:36 PM|slimbunny|LINK
Please see my codes I need to get the record count, but have not formulated the code correctly, please help with your expertise to get a record count.
Goal: Return Record Count
SELECT Acolumn1, Bcolumn2, Ccolumn3
WHERE Acolumn1 NOT IN (SELECT
Instead of getting rows back how do I get a record count from the above query?
Feb 27, 2019 05:58 PM|mgebhard|LINK
See the SQL docs.
WHERE Acolumn1 NOT IN (SELECT Acolumn1 FROM MyTable2 )
Also, NOT IN can cause issues if there are NULL values in MyTable2.Acolumn1. A Join is better as it handles NULL as you likely expect.