How to SELECT to multiple tables?

Question

MySQL

Hello. I have the following query (shown below). Three tables (office_event, accounting_event, production_event). The structure is the same for all (id, uid, uname, udate, ustatus). How to make such request to all three tables? Thanks in advance.

SELECT id FROM office_event WHERE udate >= CURDATE() AND uid = :uid

Answer 1

How to form an sql query to search multiple tables at the same time?

Question asked 58 minutes ago