Query Oracle table and local Access table with one sql statement

[jogunjobi]

Hello,



I have a situation and I really need help with that. I have an access form that I use to query Oracle tables (via ODBC). Right now, I'm trying to run a SQL query against an Oracle table using values from a local Access table. I keep getting an "ORA-00942 error:table or view does not exist" basically telling me that the Local Access cannot be found. See SQL below.

SELECT column1, column2, column3
FROM OracleTable
WHERE column1 IN (SELECT column4 from AccessTable WHERE column5 = 'text')

Any help with the sql syntax will greatly appreciated. Thanks

[June7]

You can successfully query each table individually?

Can you build a query that joins the two tables on fields column1 and column4?