SELECT Jomast.fjobno, Jomast.fpartno, Jomast.fsono, Jomast.fstatus,; > Jopact.fjobno, Jopact.flabact, Jopact.fmatlact, Jopact.fovhdact,; > Jomast.fopen_dt; > FROM ; > M2MDATA!JOMAST ; > INNER JOIN M2MDATA!JOPACT ; > ON Jomast.fjobno = Jopact.fjobno; > WHERE Jomast.fstatus = ( "RELEASED" ); > OR Jomast.fstatus = ( "COMPLETED" ); > AND Jomast.fopen_dt > ctod("01/01/2006") ; > ORDER BY Jomast.fpartnoTry using IN operator instead, e.g.
SELECT Jomast.fjobno, Jomast.fpartno, Jomast.fsono, Jomast.fstatus,; Jopact.fjobno, Jopact.flabact, Jopact.fmatlact, Jopact.fovhdact,; Jomast.fopen_dt; FROM ; M2MDATA!JOMAST ; INNER JOIN M2MDATA!JOPACT ; ON Jomast.fjobno = Jopact.fjobno; WHERE Jomast.fstatus IN ( 'RELEASED' , 'COMPLETED' ); AND Jomast.fopen_dt > ctod("01/01/2006") ; ORDER BY Jomast.fpartno