MySQL Forums
Forum List  »  Optimizer & Parser

How to make this query faster? UNION + Inner Join
Posted by: Robin Bartholdson
Date: February 21, 2007 05:23AM

SELECT titlar.id AS id, titlar.titel AS titel, titlar.skaparnamn AS skaparnamn, titlar.datumtid AS datumtid, titlar.private AS private
FROM titlar
UNION ALL SELECT trad.titelid AS id, titlar.titel AS titel, trad.skaparnamn AS skaparnamn, trad.datumtid AS datumtid, trad.private AS private
FROM trad
INNER JOIN titlar ON titlar.id = trad.titelid
ORDER BY `datumtid` DESC
LIMIT 1


Thanks very much in advance!
Robin

Options: ReplyQuote


Subject
Views
Written By
Posted
How to make this query faster? UNION + Inner Join
10501
February 21, 2007 05:23AM


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.