SELECT in ADO problems ..

In ADO, how do we make a SELECT statement that can receive fields from two tables from two different MS Access database ?

And, how come I can't use 'LEFT JOIN' clauses in SELECT statement ? I am using Access 2000. The way I query the database is like -

SET rst = NEW ADODC.recordset
rst.Open QueryStr,Conn,adKeyset,adLockReadOnly,adcmdText

first question: You could use ADO data shaping to join recordsets, or you could create a separate MDB file and link the two tables from the different databases.

I suppose you could also use jet sql to join the two tables as well.....

second question: what does your SQL look like?

How to use ADO data shaping ?

As for the SQL -

SELECT * FROM Table1 LEFT JOIN Table2 WHERE 1=1

Thanks.