How to output from two tables and sort by date?

N

Name2019-09-12 11:18:25

SQL

Name, 2019-09-12 11:18:25

There are two tables
t1
"id" "text" "date"
1 - a - 2018-01-01
2 - b - 2018-01-03
3 - c - 2018-01-05
t2
"id" "fulltext" "add_date"
6 - one - 2018-01-02
7 - two - 2018-01-04
8 -three -
2018-01-07 to
get
a
one
b
two three

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

L

Lazy @BojackHorseman, 2019-09-12
SQL

UNION ALL + ORDER BY + LIMIT

Similar questions

V

varhin2018-11-17 18:12:49

Processor choice? 4Reply

P

pfemidi2018-12-11 16:52:45

How to create progress bar like in Visual Studio Community installer? 2Reply

S

Stanislav Shabalin2020-07-15 13:33:46

How to optimize SQL query using JOIN for same nested SELECT? 1Reply

L

lexstile2018-07-25 21:51:19

How to correctly compose a select query so that the sum of two columns is less than the specified value? 1Reply

M

Mikhail Tchervonnko2013-12-03 15:58:34

How to organize the table structure for scheduling time resources? 1Reply

Didn't find what you were looking for?

Ask your question