RE: How to get full column name (table name and column name) from query results? - Kevin Turner - com.mysql.lists.dotnet

8 messages in com.mysql.lists.dotnetRE: How to get full column name (tabl...

From	Sent On	Attachments
Bob Dankert	31 May 2005 08:52
Kevin Turner	31 May 2005 10:46
Bob Dankert	31 May 2005 11:09
Andrés Villanueva	31 May 2005 11:30
Kevin Turner	31 May 2005 11:41
Bob Dankert	31 May 2005 12:01
Jerome Wilson	31 May 2005 15:11
Kevin Turner	31 May 2005 15:27

Subject:	RE: How to get full column name (table name and column name) from query results?
From:	Kevin Turner (kevi...@coraltree.co.uk)
Date:	05/31/2005 10:46:39 AM
List:	com.mysql.lists.dotnet

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:bo...@nvsn-it.com] Sent: 31 May 2005 16:53 To: dot...@lists.mysql.com 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

bo...@nvsn-it.com

v. 608.256.5680

f. 608.256.3780