Re: Getting the Parent Table for Returned Columns in a Relational Search

2004-01-11 Thread Ivan Cukic (Foment)
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

Re: Getting the Parent Table for Returned Columns in a Relational Search

2004-01-11 Thread Roger Baklund
* David Hutchison > 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

re: Getting the Parent Table for Returned Columns in a Relational Search

2004-01-11 Thread jeremy_march
Are you working from the mysql command line client? If so you can't. If not what sort of client are you working with? There isn't much to go on from your description. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Getting the Parent Table for Returned Columns in a Relational Search

2004-01-11 Thread David Hutchison
Dear all, 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. I think you need

Getting the Parent Table for Returned Columns in a Relational Search

2004-01-10 Thread David Hutchison
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 co