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


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


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