[AccessD] Open two MDBs at once

I believe you are looking for an outer join query:
 
SELECT * FROM tblAccounts 
LEFT JOIN [c:\mdb2.mdb].tblAccounts AS tblAccounts2 
ON tblAccounts.AccountID = tblAccounts2.AccountID
WHERE tblAccounts2.AccountID Is Null;
 


-----Original Message-----
From: Arthur Fuller [mailto:artful at rogers.com]
Sent: Wednesday, February 05, 2003 10:06 AM
To: AccessD
Subject: [AccessD] Open two MDBs at once



I should know this, but I don't. Assume two structurally identical MDBs, but
their rows differ. The goal is to identify the rows in MDB2 that do not
occur in MDB1; then to present them as a multi-select list; and finally to
import the selected rows into MDB2 from MDB1.

TIA.

A.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030205/db57b7d0/attachment-0002.html>