Luis G said:
right, WTF...
what's the SQL query it is using for both cases?
This one is correct:
SELECT `current month`.HSTR, `current month`.HDAT, `current month`.HCTP, `current month`.HCCD, `current month`.HCAT, `current month`.HITM, `current month`.HMFG, `current month`.HQTY, `current month`.HCST, `current month`.HSLS, `current month`.HCUS
FROM `current month` `current month`
WHERE (`current month`.HCTP='a') AND (`current month`.HCAT>='01' And `current month`.HCAT<='10') AND (`current month`.HMFG='g') AND (`current month`.HCUS>0)
ORDER BY `current month`.HSTR, `current month`.HDAT
This one is not:
SELECT `current month`.HSTR, `current month`.HDAT, `current month`.HCTP, `current month`.HCCD, `current month`.HCAT, `current month`.HITM, `current month`.HMFG, `current month`.HQTY, `current month`.HCST, `current month`.HSLS, `current month`.HCUS
FROM `current month` `current month`
WHERE (`current month`.HCTP='a') AND (`current month`.HCAT>='01' And `current month`.HCAT<='10') AND (`current month`.HMFG='g') AND (`current month`.HCUS<>0)
ORDER BY `current month`.HSTR, `current month`.HDAT
I don't see any other difference. Weird, huh?