Help selecting data from 2 duplicate tables

[burncycle]

Here's what i what to do. I have 2 tables that have the same fields but one table is for some users and the other is for other users. I have a to 10 new thing list that I want to take the top 10 newest records from these tables combined. So i can show stuff from both sets of users in one list.

Sample setup:

select id,name from table1 order by date

select id,name from table2 order by date

How do I take these 2 queries and make one big on that takes the info from both tables and orders it by date so i can list the 10 newest from both tables in one list?

[ultraslacker]

UNION will do this - check if your dbms supports it.