2. ASPRunnerPro General questions
  3. Pull Info from Multiple Tables
This topic is locked

Pull Info from Multiple Tables

 		7/27/2006 2:01:10 AM
ASPRunnerPro General questions
N
 noelc author

Hi,
i am new to this software - anyone know how to have information from 2 tables show up on 1 screen.
the problem I have is that the images are in 1 table as BLOBS and the details for the record are in another - linked by ID number.
I want the main screen to show the details for the record and display the appropriate image for the record, all on the one screen.
J
 		Jane 7/27/2006

Hi,
you can do it modifying SQL query on the Edit SQL query tab (step 4) in the ASPRunner.

Here is an example:

select [table1].[field1],

[table1].[field2],

[table2].[field3]

from [table1] inner join [table2]

on ([table1].[field1]=[table2].[field3])



See more info about join clause in the ASPRunner help:

using join clause