Adding 2 tables together

[ephemie]

I have 2 news tables (news4 & news5) with the same structure. (ID, Entry_Date, Title & Message)

At the moment I can display one table with:
strSQL = "SELECT * FROM news4 ORDER BY ID LIMIT 0,10"
Set rstCurrent = conCurrent.Execute(strSQL)

However, i would like to include the most recent records from news5 first. ie. Display table news5 and then news4.

If i include news5 as such "FROM news4, news5 ORDER
i get order problems.

Any help would be appreciated. With thx.

[r937]

  ( SELECT 5 as sortkey, * FROM news5 )
union all
  ( SELECT 4 as sortkey, * FROM news4 )
ORDER BY sortkey desc, ID 
LIMIT 0,10