Most Urgent

[essnrv]

Hi all,
Is there any way to select all fields from 2 tables in different databases?

Thank you

 

[gavinjb]

The Only way I know of is using Source Database & Source Connection Str in the Properties window in Query Desginer. (These enable you to connect to a table on a remote source file).

 

[jrbarnett]

Create a link to the foreign table and then do a select query with all fields from both tables.
Be sure to join them on appropriate fields though or you will get a cartesian product of the two tables (ie for every row in table a you will get one row from table b)

John

 

[essnrv]

I figured Out You can access two tables in 2 different databases.

select * from Table1 A, (C:\dbpath\db1.mdb.Table2 B) where A.juliandate =8642 AND A.id=B.id

Thank you