Re: Selecting from two unrelated tables

[Bricklen Anderson <banderson@xxxxxxxxxxxx>]

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;