Dear all,
I have a table with eight columns.
My selection is majorly based on 2 feilds called LS and CODE (none of them are uniq).
select * from mytable where LS in (10,20,30,40) ...
but I want the result only for those CODES which have 'all' the LS mentioned here ie., 10,20,30 an 40.
How can I do this.
Hope my question is clear.
Thanks in advance.
Best
Thangudu
I have a table with eight columns.
My selection is majorly based on 2 feilds called LS and CODE (none of them are uniq).
select * from mytable where LS in (10,20,30,40) ...
but I want the result only for those CODES which have 'all' the LS mentioned here ie., 10,20,30 an 40.
How can I do this.
Hope my question is clear.
Thanks in advance.
Best
Thangudu