This topic is locked

query more than one table

6/6/2007 9:24:37 AM
ASPRunnerPro General questions
G
guenterfrank author

Hallo together,
at first - sorry about my englisch, i am from germany
then - sorry about the question it may be stupid but i am new with asp runner and not really good with asp (thats why i am using asp runner ;-)
last, - i have searched an read anything in the forum and the help also, tryed a lot in two days but i gues i have not the right entry to solve my problems.
OK, here ist the descriptiopn of the problem, - Access database around technical gases with a lot of tables.
I slould create datasheets of the technical gases, so that in case of an emergency first aid is possible.
All the things i need are in 4 different tables, from SDB_1 to SDB_4.
Its no problem to build a query along one table and build a list view with the name of the gas and an emergency phone number, because these information are stored in the table SDB_1.
The problem is, that from this list View i want to jump by a link to a self created data sheet witch contains informationes of all 4 tables, (from SDB_1 to SDB_4).
The tables are with an ID number in a 1:1 relationsship connected.
I am using asp runner pro 5.0, (just buyed and hoply not for nothing)
best regards
Guenter
Is there any idea

Sergey Kornilov admin 6/6/2007

You need to use SQL JOIN query to pull data from all four tables at once.

Here is the article that explains how you can do this:

http://www.xlinesoft.com/asprunner/docs/us...sql_queries.htm
I can also suggest to design your query in Query Designer in MS Access, save it in your database and use this query as a datasource in ASPRunnerPro.