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;

Tigers have no natural predators. They love water and are great swimmers. Oh... and they purr as well as roar.

While no two tigers are striped exactly the same (stripes even vary on each side of the animal), all tigers have a set of three lines on their forehead as represented by Wang - the Chinese symbol for King.

This Chinese character features Wang, the Chinese Symbol for King three transverse lines representing the heaven, people and earth respectively.

When linked by the vertical line "|", a character comes into being representing the one owning the absolute authority of the world, the king.

Of the eight sub-species of tiger, three—the Caspian, Balinese, and Javan—are considered extinct, and the remaining five are critically endangered.

Estimates put the most numerous of the tigers, the Bengal, at 3,000–5,000 in the wild, primarily in India. This is more than the other four sub-species combined.

Query Data In Two External Access Files and Join Results

Tigers

Recent Posts