| CARGO LAMA IMPORT |
SELECT TPlanningMasuk.TPlanningMasuk_PK, TPlanningMasuk.TglMasuk, TCONSOLIDATOR.NAMACONSOLIDATOR, TRacking.NamaRack, TRELEASE.TGLRelease, TJOBORDER.NOJOBORDER, TMANIFEST.NOTALLY FROM TRELEASE RIGHT JOIN TMANIFEST ON TRELEASE.TMANIFEST_FK = TMANIFEST.TMANIFEST_PK LEFT JOIN TRacking ON TMANIFEST.TMANIFEST_PK = TRacking.TMANIFEST_FK RIGHT JOIN TJOBORDER LEFT JOIN TCONSOLIDATOR ON TJOBORDER.TCONSOLIDATOR_FK = TCONSOLIDATOR.TCONSOLIDATOR_PK RIGHT JOIN TCONTAINER ON TJOBORDER.TJOBORDER_PK = TCONTAINER.TJOBORDER_FK ON TMANIFEST.TCONTAINER_FK = TCONTAINER.TCONTAINER_PK RIGHT JOIN TPlanningMasuk ON TCONTAINER.TCONTAINER_PK = TPlanningMasuk.TCONTAINER_FK order by TPlanningMasuk.TglMasuk desc