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