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.