Select two fields from different MS-Access Databases

[PalaniappaBabu]

Is it possible to Select two fields from different MS-Access Databases?

 

[JerryDennison]

You can link tables from just about as many Access databases you want.

 

[PalaniappaBabu]

Is it possible through a SQL Statement?

For Ex : Select a.No, b.Name
from db1.Employee a, db2.Employee b;

 

[JerryDennison]

So long as you've linked the two tables to the database you can. There will need to be a common field value between the two tables for establishing a relational join.

 

[PalaniappaBabu]

The problem is there must not be any joins (i.e, I must not create any joins). I have to do this with a SQL statement.
Is it possible?

 

[tomschafer]

Try this....

SELECT FieldName
FROM TableName IN 'c:\directory\db1.mdb';

UNION ALL

SELECT FieldName
FROM TableName IN 'c:\someotherdirectory\someotherdb1.mdb';