How to join multiple tables on one field?

Question

MySQL

There is a working request. It will append to main_tbl2 an additional table dopstr_tbl2 with a comparison field marker_dop

SELECT `main_tbl2`.*, `dopstr_tbl2`.* FROM `main_tbl2` 
LEFT JOIN `dopstr_tbl2` ON `main_tbl2`.`alias` = `dopstr_tbl2`.`marker_dop`

How to write a query so that the same comparison also goes through the tables dopstr_tbl3 dopstr_tbl4 dopstr_tbl5 ?

Answer 1

The same as with the dopstr_tbl2 table.

SELECT 
     `main_tbl2`.*,
     `dopstr_tbl2`.*, 
     `dopstr_tbl3`.* 
FROM `main_tbl2` 
     LEFT JOIN `dopstr_tbl2` ON `main_tbl2`.`alias` = `dopstr_tbl2`.`marker_dop`
     LEFT JOIN `dopstr_tbl3` ON `main_tbl2`.`alias` = `dopstr_tbl3`.`marker_dop`