get the table name from a field for 3 different tables

2003-03-27 Thread Daniel Rossi
hi there i would like to find out how to get the table from a field if i am joining three tables together for instance select a.id, b.id, c.id from a, b, c when i get the results i need to be able to get the table name a if i get the result from a.id , is it possible ? -- MySQL General

Re: get the table name from a field for 3 different tables

2003-03-27 Thread Jeff Shapiro
At 15:40 +1100 3/28/03, Daniel Rossi wrote: hi there i would like to find out how to get the table from a field if i am joining three tables together for instance select a.id, b.id, c.id from a, b, c when i get the results i need to be able to get the table name a if i get the result from