Rather than the USING clause couldn't you use the ON clause, i.e.
select * from table1 as t1 join table2 as t2 on t1.<column> =
t2.<column>;
Where <column> is the name of your (duplicate) column in each table.
-----Original Message-----
From: Bob Dankert [mailto:bob@stripped]
Sent: 31 May 2005 16:53
To: dotnet@stripped
Subject: How to get full column name (table name and column name) from
query results?
Using the MySqlDataReader to get the results from a query, is it
possible to get the full columns names from the DataReader (table name
and column name)? I have many queries that join tables with the same
column names, and to distinguish which column is which I would like to
know the table name as well as column name. Currently, I get the column
name from MySqlDataReader.GetName(index), and the query is rather
general: select * from table1 join table2 using (index);
Thanks,
Bob
Envision Information Technologies
Associate
bob@stripped
v. 608.256.5680
f. 608.256.3780
"NOTICE: The information in this electronic mail transmission is intended by CoralTree
Systems Ltd for the use of the named individuals or entity to which it is directed and
may contain information that is privileged or otherwise confidential. If you have
received this electronic mail transmission in error, please delete it from your system
without copying or forwarding it, and notify the sender of the error by reply email or by
telephone, so that the sender's address records can be corrected."
