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]