ODBiC Discussion Board

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


Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.