Tried that earlier and it still ignored it plus it doesnt give me the right results. For some reason it just wants to completely ignor it. Here is the whole thing.
Code:SELECT clname1, clnum, (SELECT tklast FROM timekeep WHERE tkinit=corgaty), (SELECT tkfirst FROM timekeep WHERE tkinit=corgaty), mdesc1, mmatter, (SELECT tklast FROM timekeep WHERE tkinit=msupaty), (SELECT tkfirst FROM timekeep WHERE tkinit=msupaty), mstatus, clstatus FROM matter AS a INNER JOIN client AS b ON b.clnum=a.mclient WHERE b.clstatus='C' AND a.mstatus='OP' AND b.corgaty='0575' OR a.msupaty='0575'




Reply With Quote