I would be pleased if somebody could help me in my problem. I have two Access97 databases (not those two down here but somewhat more complex but these are fine for example).

Database 'C:\WINNT\Profiles\peltojo\Desktop\Customers.mdb'
having Customer table
ID
Name
Address

Database 'C:\WINNT\Profiles\peltojo\Desktop\Orders.mdb'
having Orders table
CustomerID
ProductName
Price

Now I should to make SQL query WITHOUT linking Orders database to Customers database. E.g.

SELECT
Customer.Name, Customer.Address, Orders.ProductName, Orders.Price
FROM
Customer IN 'C:WINNT\Profiles\peltojo\Desktop\Customer.mdb',
Orders IN 'C:\WINNT\Profiles\peltojo\Desktop\Orders.mdb'
WHERE
Customer.ID = Orders.CustomerID;

What is the correct syntax? I guess this kind of query should be possible anyway.

Yours,
Peltsi