Master: Can this SQL statement can be changed to a connection query? Servers: overmind (overmind) level: credit value: 100 community: Oracle development problem points: 100 Reply times: 6 Posted: 2004-12-14 10:31:43
Select T1.Oid from T1 Where T1.OID NOT IN (SELECT OID from T2 Where T2.Userid = 'overmind');
Reply to: OVERMIND () Reputation: 100 2004-12-14 10:32:07 Score: 0
Thank you!
TOP
Reply to: orarichard (there is no money to be very difficult) () Reputation: 100 2004-12-14 10:38:00 Score: 100
Select T1.Oid from T1, (Select Oid from T2 Where T2.Userid = 'overmind') T3
WHERE T1.OID <> T3.OID
TOP
Reply to: orarichard (no money is so difficult) () Reputation: 100 2004-12-14 10:40:49 Score: 0
is acceptable
SELECT T1.OID from T1,
(
SELECT OID FROM T1
minus
Select Oid from T2 Where Userid = 'overmind'
) T3
WHERE T1.OID = T3.OID;
