subtracting statments
I have two statements:
Select name from users
(this returns - user1, user2, user3)
Select name from installmatrix inner join
users on installmatrix.uid = users.uid where installmatrix.sid = 2
(this returns - user1, user3)
I want to subtract the 2nd from the 1st, so I use:
Select name from users where name not in
(Select name from installmatrix inner join
users on installmatrix.uid = users.uid where installmatrix.sid = 2)
(this should return user2, BUT I get a big fat sql error)
Pls Help!!! :)
Subject
Written By
Posted
subtracting statments
August 19, 2004 08:34AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.