2. ASPRunnerPro General questions
  3. using multiple table
This topic is locked

using multiple table

 		5/25/2007 7:23:54 AM
ASPRunnerPro General questions
R
 rignesh author

hi
I m developing an application which get's records from sql view.Now I need to get result from one more table which will

use one field of first view as a selection criteria.
For example:
the first result set gives me..name,phone no.address,location1..from userinfo table.
Now i need second result set to be display in the asp runner who will find out list locations nearby to the location1 from location table.
So on same page..i like to display data from both.
name,phone no. address,location,

location 1 nearby (from second table)

location 2 nearby (from second table)
so can anybody give solution for this?

I have created my whole project in asprunner ..but i m not getting few of the functinality like this.So i really need to solve this.
thanx in advance..
rignesh
B
 		brasil 5/25/2007

sounds like you need to use a custom SQL statement for the table you want linked to the second table (this was one of my first questions too). check out the examples in the help files which describe using an inner join in the custom SQL query field in asprunner.
basically, if you can formulate a SQL statement that will return the data you need from both tables, you can put it in asprunner and it will work. i hope that helps you, until one of the asprunner masters answers.
Sergey Kornilov admin 5/25/2007

Use JOIN SQL query for this purpose:

http://www.xlinesoft.com/asprunner/docs/us...sql_queries.htm