Postgres Pro
Downloads
Home   >   mailing lists

Selecting from two unrelated tables - Mailing list pgsql-general

From CSN
Subject Selecting from two unrelated tables
Date
Msg-id 20060920194900.54683.qmail@web52904.mail.yahoo.com
Whole thread Raw
Responses Re: Selecting from two unrelated tables  (Bricklen Anderson <banderson@presinet.com>)
Re: Selecting from two unrelated tables  (John Sidney-Woollett <johnsw@wardbrook.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Problems converting between C string and Datum
Next
From: Bricklen Anderson
Date:
Subject: Re: Selecting from two unrelated tables