Extract data from two tables and order by date
I have two开发者_如何学JAVA seperate tables:
Table1 - id, news, date_added Table2 - id, news, extra, date_addedIs it possible to query both table and extract data ORDER BY date_added
Thankstry this
select id, news, date_added,"" as extra
from table1
union all
select id, news, date_added,extra
from table1
ORDER BY date_added
精彩评论