Re: MySQL Join 4 Tables

[Thames Muthu]

here it is again given bellow.
I have 4 tables as table A, table B, table C and table D. samples are given below.

Table A (ID, Des)-primary key is ID
=================
1&emspxxx
2&emspyyy
3&emspzzz
4&emspaaa

Table B (ID, P_ID)
==================
1&emspP01
3&emspP02

Table C (P_ID, P_DATE)-primary key is P_ID
======================
P01&emsp2022/10/12
P02&emsp2022/10/19

Table D (ID, REF_NO, D_DATE)
============================
2&emspB13&emsp2022/09/30
4&emspL84&emsp2022/09/22


and so on, I need to produce the following result using a query for a given criteria (ID). Query should produce either there are matching records in table C or D as follows.


A.ID&emspA.Des&emspC.P_DATE&emspC.ITEM_NO&emspD.REF_NO&emspD.D_DATE
1&emspxxx&emsp2022/10/12&emsp40&emsp________&emsp________
1&emspxxx&emsp2022/11/05&emsp03&emsp________&emsp________
3&emspzzz&emsp2022/10/19&emsp24&emsp________&emsp________
2&emspyyy&emsp_______&emsp________&emspB13&emsp2022/09/30
4&emspaaa&emsp_______&emsp________&emspL84&emsp2022/09/22