Query Tables From 2 Different DB using JOINS

[Miked811]

Hi Guys,

How do i query tables from 2 different databases using "JOINS" and without doing a "link" from the other database.

I can do this:

SELECT TblName.* FROM TblName IN 'c:\DB\DBName.mdb'

I tried to add a JOIN but it says syntax error FROM...Please help

Thanks

 

[PWise]

SELECT TimeSheet.* FROM TimeSheet 
inner join (SELECT Employees.* FROM Employees IN '\\Server\DATA\pwdocs\be.mdb')em ON TimeSheet.Empid = em.Empid
IN '\\Server\DATA\pwdocs\timeclockbe.mdb'

 

[PWise]

if both tables are in the same remote db you can use this sql statement

SELECT TimeSheet.* FROM TimeSheet 
inner join Employees as em ON TimeSheet.Empid = em.Empid
IN '\\Server\DATA\pwdocs\timeclockbe.mdb'

 

[Miked811]

Thank you very much pwise, it worked...I have to do some adjustments with the remote DBs and wella...