I'm hoping someone will help me changing BusinessObjects sql to QV set analysis. I'm having a hard time matching up data with the equivalent OR and AND operators in set analysis. Does anyone see anything that is wrong?
The records must meet the first criteria and then either the first OR stmt or the 2nd stmt.
--business objects sql query
AND scorpion.a_segatyelm.segaty_cd = 'C'
AND scorpion.a_agtdty.agt_dty_cd NOT IN ( 'R','0' )