CSN wrote:
I have two tables:
items: id, title, added, ...
news: id, headline, datetime, ...
I'd like to select the latest 25 combined records from both tables. Is there a
way to do this
using just select?
Thanks,
csn
Maybe something like this?
select id,title_headline,dt
from (
select id,title as title_headline,added as dt from ...
union all
select id,headline as title_headline,datetime as dt from ...) as a
order by dt limit 25;
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
