I have 2 tables that have the same field names so I'm wondering if we can do an assignment like below:<BR>cost=rs("table1.price")<BR>or <BR>Response.Write rs("table1.price")<BR>Thanks!<BR><BR>
Try it and find out.
1. SQL = "SELECT table1.price AS P1, table2.price AS P2 ..."<BR>2. COST_1 = rs("P1")...<BR><BR>Good luck!
It gives me an error...<BR>I'm just not sure if the syntax is right or not..<BR>Is there some other way to display 2 fields that have the same names but from different tables?
I also tried this way but didn't work... <BR>This is the error I get "Unable to understand after DECLARE..."
<BR>Try assigning each table to each recordset<BR><BR><%=rs1("price")%><BR>&# 060;%=rs2("price")%><BR><BR>
Post your SQL pls