SELECT i.* from table1 i WHERE (( i.field2 = "FA" and i.field3 = 0) OR EXISTS (SELECT * from table2 s WHERE s.key1 = i.key1 and s.fielda <> "X" and s.fieldb <> "I")) AND NOT EXISTS(SELECT * from table3 a WHERE a.key1 = i.key1 AND a.field4 = i.field4) ORDER BY i.field4>I need to do the following:
>SELECT i.* from table1 i > WHERE (IF exists) (SELECT * from table2 s WHERE s.key1 = i.key1 and s.fielda <> "X" and > s.fieldb <> "I") > AND i.field2 = "FA" and i.field3 = 0 > AND NOT EXISTS(SELECT * from table3 a WHERE a.key1 = i.key1 AND a.field4 = i.field4) > ORDER BY i.field4 >>In other words,
>SELECT i.* from table1 i > WHERE EXISTS (SELECT * from table2 s WHERE s.key1 = i.key1 > AND s.fielda <> "X" AND s.fieldb <> "I") > AND i.field2 = "FA" and i.field3 = 0 > AND NOT EXISTS(SELECT * from table3 a WHERE a.key1 = i.key1 > AND a.field4 = i.field4) > ORDER BY i.field4 >>