Selecting from two unrelated tables

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Selecting from two unrelated tables
Date: 2006-09-20 19:49:00
Message-ID: 20060920194900.54683.qmail@web52904.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bricklen Anderson 2006-09-20 19:57:28 Re: Selecting from two unrelated tables
Previous Message Martijn van Oosterhout 2006-09-20 19:29:47 Re: Problems converting between C string and Datum