RE: MS access databse with multiple tables, Scott S, 01-04-2005
ODBscript uses ODBC, so it's ANSI-standard SQL
by Roger Harris, January 5, 2005 06:52
To get data from two or more tables, you have to "join" the tables, and the MS-Access ODBC driver supports the ANSI-standard syntax for that. You can use a Web search to find a lot of SQL tutorials online to explain how this is done. Below is a link to one I found with a quick search, which has three sections on joins, but there may be better ones out there.
sqlzoo.net SQL Tutorial
Name E-mail optional TopicMessage:
HTTP Link: Link text: