user350230
Reputation: 73
Extract data from two tables and order by date
I have two seperate tables:
Table1 - id, news, date_added
Table2 - id, news, extra, date_added
Is it possible to query both table and extract data ORDER BY date_added
Thanks
Upvotes: 0
Views: 458
Answers (1)
SQLMenace
Reputation: 134941
try this
select id, news, date_added,"" as extra
from table1
union all
select id, news, date_added,extra
from table1
ORDER BY date_added
Upvotes: 1
Related Questions
- Query two tables ORDER BY date
- order by with dates from two tables
- MySQL Selecting from two tables ordered by date
- MySQL order by other tables row
- MySQL - Getting data from separate tables and sorting by their dates
- How to get details of two tables using order by date in mysql
- ordering 2 tables by date
- Select two table and order by date
- Order by date from 2 tables
- Select separate rows from two tables, order by date