Re: using IN, but the value must be in all of them
YOU need to provide in clause for the column,
ex : select * from table1 where name = 'mauricio' AND type IN ('STAFF','MANAGER','CLIENT')
here it search for name and type column if true , then it result the answer, if false then it doesnt
to display all I think you need to use Join Statement
Subject
Views
Written By
Posted
2040
May 12, 2011 11:42AM
Re: using IN, but the value must be in all of them
809
May 24, 2011 12:19AM
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.