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: Anjan 25 Jul 2008 | Member Level: Silver | Rating:  Points: 3 |
You can use like the following way,
SELECT field1,field2 FROM MASTER WHERE field1 in (SELECT field1 FROM TABLE) AND field2 IN (SELECT field2 FROM TABLE)
|