Kyrby is a user on teamtk.eu. You can follow them or interact with them if you have an account anywhere in the fediverse.

(MySQL)
Let's say I have 2 tables and in each one I have a 'date' column. How can do a SELECT on both tables ordered by date?

Kyrby @kyrby

@angristan
Select * from (Select * from t1
Union
Select * from t2) as tmp
Order by date