How to make this query faster? UNION + Inner Join
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
Subject
Views
Written By
Posted
How to make this query faster? UNION + Inner Join
10501
February 21, 2007 05:23AM
3578
May 16, 2009 08:47AM
4108
May 16, 2009 11:02PM
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.