Pulling data from different dB Tables..

[Webflex]

Can anyone point me at a good tutorial or example on pulling data from different tables in a db (Access) and combining the results in one page. I am comfortable working with one table with ASP/Access and inserting/deleting/searching etc.

Thanks in advance

 

[JoliM]

You probably need to get a good SQL reference book to help you learn SQL. In the meantime, for a tutorial online go to

http://www.1keydata.com/sql/sql9.html

Displaying data on a single page from different tables is not any different than displaying data from one table. What is different is the SQL statement that you have to write to get the data you want.

To join Table A with Table B, each table has to have a column that has values that are the same such as an ID column.

So

Select A.*, B.* from TableA A, TableB B
where A.ID = B.ID

You can also select certain columns in the tables based on what you need by replacing the A.*, B.* (which selects all columns in both tables).

Hope that helps,
Joli

 

[Webflex]

Thanks, that was helpful, can you recommend a good usable SQL book for Web Programming, it seems to be a bit of a minefiled out there.

 

[JoliM]

Unfortunately, I haven't found a great SQL book to recommend. We have a copy of SQL for Dummies which may be a good start.

Joli