Hello everyone,
I am trying to combine two table values which are duplicate in both column. I want to exclude duplicate value from both tables.
How can I do that?
Below is my current query and I want to group by PO_NUM or Bill_OF_LADING.
Select C.ACTL_EQUIP_TY_CD,C.CNTR_ID,A.PO_NUM,A.DC_NUM,C.LAND_CARR,B.VEND_NM,G.MCH2_DESC,B.VEND_NM,E.BOL_NUM,C.APPT_TMS,D.LOAD_ID,D.LEG_NUM,A.BOL_SEQ_NUM,A.SHIP_NUM, A.SHIP_ST_CD,C.PKUP_NUM,C.BK_NUM,D.APPT_TMS,D.PKUP_TMS,DELV_TMS
from ICTLAO0.PO_HDR A
Left join ICTLAO0.dhl_doc_validate B
on A.PO_NUM = B.PO_NUM
Left join ICTLAO0.CNTR C
on A.CNTR_SEQ_NUM = C.CNTR_SEQ_NUM
Left join ICTLAO0.LOAD D
on A.CNTR_SEQ_NUM = D.CNTR_SEQ_NUM
Left join ICTLAO0.BILL_OF_LADING E
on A.BOL_SEQ_NUM = E.BOL_SEQ_NUM
Left join ICTLAO0.MCH_REF G
on A.ST_CD = G.ST_CD
