[Tesco]

Back again,
This time, I'm selecting data from two tables at once. My SQL query is working fine, but my problem is, I have columns in each table that have the same name, example:
table_1
column_1
column_2
table_2
column_1
column_2

What I want to know is, how can I reference to only the value of column_1 in table_1 and not column_1 in both? I've tried something similar to:
<%=rsLa("table_1.column_1")%>
But I'm getting a error saying that the item cannot be found. If it's any help, my SQL query is below.

Code:

"SELECT * FROM tbl_Cars, tbl_Votes WHERE tbl_Cars.UserID = '" & Request.Cookies("JuicedTuning")("UserID") & "'"

Any Ideas?
ta

This is how i do it

the c and the v after each table is a alias that can be used to reference it.

"SELECT * FROM tbl_Cars c, tbl_Votes v WHERE c.UserID = '" & Request.Cookies("JuicedTuning")("UserID") & "'"

then to output,

response.write(rs("c.col1")) cars or response.write(rs("v.col1")) if you wanted the votes

hope that makes some sense

edit: i see no actual errors with your code though.... & first line changed

[Tesco]

Thanks koncept, but as soon as I reference to one of them, I'm still getting a error:
Item cannot be found in the collection corresponding to the requested name or ordinal.

silly me, i forgot to link the tables

what it is doing now is creating a cartesian product (garbage) it is listing everything as one big table with all the columns together

this where statement links the two tables and allows you to work with them the way you want
where c.id=v.id and....