sub-query sql from access

[Alain Terranova]

Hello,

I linked two table thanks to odbc driver. I try to execute a sub-query like:

SELECT * FROM PERSON WHERE ID_PERSON IN (SELECT ID_PESRON FROM PHONE WHERE NUM_PHONE = "004589888")

OR

SELECT * FROM PERSON
WHERE EXISTS (SELECT * FROM PHONE
WHERE PERSON.ID_PERSON=PHONE.ID_PERSON AND
PHONE.NUM_PHONE="01545465456")


But seems that that odbc driver is not able to execute a sub-query....

Any ideas?.....