SQL questions???
From: Elton Chan <97980015r_at_polyu.edu.hk>
Date: 1998/06/15
Message-ID: <6m22em$vke1_at_hkpa05.polyu.edu.hk>#1/1
Date: 1998/06/15
Message-ID: <6m22em$vke1_at_hkpa05.polyu.edu.hk>#1/1
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 CEST