question about using UNION
(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???)
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.