<snip>
If you are returning the same column name from multiple joined tables, then
you have one of two problems.
(A) Either both columns mean the same thing, and contain the same data --
therefore your query is redundant and inefficient and there's no reason to
access both columns in ASP (or return them with the resultset in the first
place).
(B) Or, you chose extremely poor names for your columns. If they don't mean
the
same thing, and contain distinct data, then why do they have the same name?
</snip>
My suggestion is to fix that problem... either by eliminating redundant
columns from the SELECT statement in case (A), or by aliasing the columns in
the SELECT (or properly altering the table(s)) in case (B).
"Taper Litwater" <Li******@NOSPAM.com> wrote in message
news:ul**************@TK2MSFTNGP10.phx.gbl...
after selecting from two table like so-
select table1.column, table2.column from table1, table2 ...
What is the correct syntax to access the individual table data?
With one table I would normally just use- rs("column")
TIA