join tables from different schema

[zwasdl]

I'm using access to connect to Oracle via ODBC. I can also connect to
Oracle via sql*plus.
Can I write a query to join tables from different schema? If so, how?
Thanks a million!

Wei

[Anne Nolan]

To use 2 different schemas, you can either create Database Links in Oracle
(if the other schema is in another database), and query via pass-thru
queries;
or
You can link all the Oracle tables you need into your Access database, with
2 diff ODBC DSNs, and join away in an Access query.

Anne
<zw****@gmail.comwrote in message
news:11**********************@d34g2000cwd.googlegr oups.com...

I'm using access to connect to Oracle via ODBC. I can also connect to
Oracle via sql*plus.
Can I write a query to join tables from different schema? If so, how?
Thanks a million!

Wei

[Randy Harris]

On 22 Sep 2006 07:12:28 -0700, zw****@gmail.com wrote:

>I'm using access to connect to Oracle via ODBC. I can also connect to
Oracle via sql*plus.
Can I write a query to join tables from different schema? If so, how?
Thanks a million!

Wei

In Oracle you simply use the syntax schema.table.

SELECT
M.Field1, Y.Field1
FROM
Mine.Table M, Yours.Table Y
WHERE
M.KeyField = Y.KeyField

-=-=-=-=-=-=-=-=-=-=-=-=
Randy Harris
tech at promail dot com