Well I am still new to sql to getting better and better with each query. Now this one has me completley stumped.
Here is the query
SELECT * FROM MOTORS WHERE (CHKCANCEL = '0') AND (DITD IS NULL) AND (CUSTOMERID = '52') OR (CUSTOMERID = '62') OR (CUSTOMERID = '72')
This return 37 rows but there is two rows that have CHKCANCEL = 1