17.10.2015, 08:22
Hi, a little help with a query please?
SELECT COUNT(*) FROM `Table1` WHERE `rowid1` NOT IN (SELECT `rowid2` FROM `Table2`) AND `Timestamp` <= '60000' AND `Field2` < 3000 AND `Field3` = 0
It used to work without the ANDs, but its throwing me an error.
Nvm, its fixed.
SELECT COUNT(*) FROM `Table1` WHERE `rowid1` NOT IN (SELECT `rowid2` FROM `Table2`) AND `Timestamp` <= '60000' AND `Field2` < 3000 AND `Field3` = 0
It used to work without the ANDs, but its throwing me an error.
Nvm, its fixed.