select field1,field2 from MASTER where (field1,field2) IN (select field1,field2 FROM TABLE).
this query is not running, getting error stating that syntax error near ','.
what is the wrong with above.
if change the query then it is working.
select field1,field2 from MASTER where field1 IN (select field1 FROM TABLE).
the above query has only one field in where clause,this is working fine.
what is the wrong with first queriy.
|
| Author: abhi 25 Jul 2008 | Member Level: Bronze | Rating:  Points: 2 |
select field1,field2 from TABLE where field2 IN (select field2 FROM TABLE) And field1 IN (select field1 FROM TABLE)
|