Re: MySQL Join 4 Tables

[Phillip Ward]

[Still not what I asked for (create table, insert), but ...]
Something like this should get you close to what you want:

select 
  A.ID 
, A.Des
, C.P_DATE
, C.ITEM_NO  --- table c has no column called ITEM_NO !! 
, D.REF_NO
, D.D_DATE
from table_a A
left join table_b B 
     on A.ID = B.ID
left join table_c C 
     on B.P_ID = C.P_ID
left join table_d D 
     on A.ID = D.ID

+----+-----+------------++--------+------------+
| ID | Des | P_DATE     || REF_NO | D_DATE     |
+----+-----+------------++--------+------------+
|  1 | xxx | 2022/10/12 ||        |            |
|  2 | yyy |            || B13    | 2022/09/30 | 
|  3 | zzz | 2022/10/19 ||        |            |
|  4 | aaa |            || L84    | 2022/09/22 | 
+----+-----+------------++--------+------------+

Regards, Phill W.