David Hutchison wrote:

I am new to the list and glad to joining the MySQL community.

I am trying to ascertain the table to which each column in a MySQL record set belongs in a relational search query. There may well be duplicate column names across tables.

How can I query MySQL to tell me the parent table for each column in the record set? Thanks kindly.

dave


SELECT a.name as aname, b.name as bname FROM atable as a, btable as b WHERE ...;



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to