Query Data In Two External Access Files and Join Results

Not all Access developers are aware of the ability for Jet queries to join on tables in external database files so here is a quick example:


SELECT c.*, d.*
FROM (;database=c:\src\football\k_data.mdb) Team AS c 
INNER JOIN (;database=c:\src\football\k_data_may_2004.mdb) Team AS d 
ON c.TeamID = d.TeamID;