Hey Folks,
I'm working on a project that is calling for data from a couple of different tables in a database to be displayed on the same page. The problem is that in both of the tables, the data rows are labelled the same. What I'm thinking I need to do is assign a variable to each data row in each table, but I am having issues doing this.

For a quick example. Lets say I have a database 'blah' and in that database I have a table named: tbl1, and another table named tbl2. In each of these tables I have a row named 'id'.

I want to be able to show the data from the 'id' row from both tbl1 and tbl2.

How can I create a variable for the id in tbl1 and the id in tbl2?

Do I do it in the sql command?
Or something Else?

I tried to be as clear as I could.
Let me know if you need more details,
Thanks,
Alex

Use "AS" in your sql statement where you basically rename the column name each time the sql script runs. It doesn't change the name in the table, it only changes for the script you are running.
Example:
SELECT id AS TBL_ONE_ID, OTHER_COLUMN, ANOTHER_COLUMN
FROM tbl1

If I do that, is it okay to run 2 sql querys on the same page? I've not done that before.
What I have done so far is:
"SELECT annuityID, insComp, annName, intRate AS reg_annuityID, reg_insComp, reg_annName, reg_intRate FROM tbl_bestpick"

it errors out. obviously I'm not doing this right.
Even if I do get that to work what do I do for the other table? Just put another Select statement in?

Your error is that you're misnaming intRate.

It should be (your other table).intRate as annuityID2 (or something else different).

Also, you CAN run two SQL queries on the same page. You just need to dump your results to arrays and work with them from there.

http://www.asp101.com/samples/db_getrows.asp

There's a good sample to get you started.

Thanks guys!
That worked great!