pravinmaliye
New User
Joined: 28 Aug 2006
Posts: 9
Location: pune
|
|
|
|
HI
i have a coloumn dname i n a table
which contains a,b,c----------------
i want to write a query such as
select dname from table
where dname = a,b,c,d,e,f,g
and dname not in(m,n,a,h)
and disp=i
now dname and disp conditions should be applied for only
a,b,c,d,e,f not for all dname rows in table
so plz tell me how can i write a query |
|
stodolas
Active Member
Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin
|
|
|
|
First off your query is wrong, you have A in "dname not in" and A in the
"where dname = "
| Code: |
select dname from table
where dname not in(m,n,h)
and (dname in (a,b,c,d,e,f,g) and disp = i)
for read only with UR
|
|
|
