SQL questions???

Hi all,

    Anybody know how to replace 'NOT IN' operator by other operations?

SELECT * FROM TABLE1 WHERE
CODE1 NOT IN (
SELECT * FROM TABLE1 WHERE
( CODE1 = '1' OR CODE1 = '2' OR CODE1 = '3' ) AND
 ( CODE2='A' OR CODE2='B' OR CODE2='C')
);

ANY clue??? I've tried to use outer join, but it cannot be used with OR operation...

Thanks,
Elton Received on Mon Jun 15 1998 - 00:00:00 CDT