MySQL Forums
Forum List  »  Newbie

any alternatives for achieving "UNION " of multiple tables??
Posted by: missterie
Date: August 08, 2005 09:37AM

I have two tables with same column names. Using a union statement to display all columns found for a particular ID is my desire. E.g

select t1, t2 from table1 where ID=12 union select t1, t2 from table2 where ID=12

But Its not working in JSTL standard SQL library tag as I want it to. I only get one column even though am selecting multiple columns. Maybe due to some bug in the driver or taglib or something. I havent figured it out yet and dont have anymore time left to do so. So mySQL question is,
Is there an alternative way to achieving the union of multiple tables?

Options: ReplyQuote


Subject
Written By
Posted
any alternatives for achieving "UNION " of multiple tables??
August 08, 2005 09:37AM


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.