WHERE IN - Query

Hi everybody

Isn't it possible to extend a WHERE IN query over 2 columns - first column is number and second is char) like

SELECT * FROM TABLE1 WHERE (ID, NAME) IN (SELECT ID_2, NAME_2 FROM TABLE2) Thanks for your help

Joerg Received on Thu Apr 22 1999 - 04:57:39 CDT