-
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.