It would be great if someone can help me with that.
I'm trying to join two tables, one of them in an external database, and I didn't find the right syntax for that till now.
Here is my SQL statement:

datEGS.RecordSource =
"SELECT code.description, Session.Name, Session.Date
FROM Session INNER JOIN Code IN 'c:\Prj5\Codetbl.mdb'
ON Session.No = Code.No"

datEGS is a data control (DatabaseName is the current database),
Session is a table in the current database,
and code is a table in an external database Codetbl.mdb

Thanks,