MySQL Forums
Forum List  »  Newbie

question about using UNION
Posted by: huseyin YILDIRIM
Date: April 21, 2005 09:10AM

(SELECT id,name FROM table1)
UNION
(SELECT id,name FROM table2)
UNION
(SELECT id,name FROM table3)
order by name limit 1;


this query is works. I can get the fields values. But i cant get the owner table that i read.

for example i get this values

3,george

(which table has this record???)

Options: ReplyQuote


Subject
Written By
Posted
question about using UNION
April 21, 2005 09:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.