MySQL Query
What is wrong with this:
(SELECT * from wot_head order by date desc) UNION (SELECT * from wo_head order by date desc)
It returns the right result but they are NOT ordered by the column date.
Both tables have identical columns, both have a column named date
(SELECT * from wot_head order by date desc) UNION (SELECT * from wo_head order by date desc)
It returns the right result but they are NOT ordered by the column date.
Both tables have identical columns, both have a column named date
Last Comment
ASKER
To DaveBaldwin
There is an order by clause after BOTH selects. It's not capitalized, does that matter?
Or is MySQL confused because there are two date columns? Do I have to specify which date field in which table (ie, order by wot_head.date)?
Oh maybe I have to put the order by AFTER the UNION business?
There is an order by clause after BOTH selects. It's not capitalized, does that matter?
Or is MySQL confused because there are two date columns? Do I have to specify which date field in which table (ie, order by wot_head.date)?
Oh maybe I have to put the order by AFTER the UNION business?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
What Dave said...
Change to:
SELECT * from wot_head
UNION
SELECT * from wo_head
order by date desc
Change to:
SELECT * from wot_head
UNION
SELECT * from wo_head
order by date desc
ASKER
Thanks, Dave.
MySQL Server
MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.
49K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
(SELECT * from wot_head) UNION (SELECT * from wo_head ) ORDER BY date desc