Re: MySQL Join 4 Tables

[Thames Muthu]

Thanks Phillip
It works pretty fine until both tables (Table C and Table D) have matching records. But failed to produce result when there are no matching records in either Table C or Table D.

select
A.ID
, A.Des
, C.P_DATE
, C.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
where A.ID = 1

** I wrote a Union Query that works pretty fine by adding criteria for each set.

kind regards