How to make a selection from multiple tables?

Question

MySQL

Hello,
there are 2 tables:

withdraw

incomes

how do i find all records where user 1 and sort by date and time ?

Answer 1

SELECT * FROM (
 SELECT w.user, w.amount, w.time, w.date
  FROM withdraw w
  WHERE w.user=1
 UNION
 SELECT i.user, i.amount, i.time, i.date
  FROM incomes i
  WHERE i.user=1
)
ORDER BY 3, 2