SELECT A.TCARGOWORKORDER_PK,A.TGLENTRY,A.JamEntry,A.TWORKORDER_FK,A.TCONSOLIDATOR_FK, A.NOCARGO,C.NAMACONSOLIDATOR,B.NOWO,E.KODEPACKING,E.NAMAPACKING,D.QUANTITY,D.DESCOFGOODS, D.MARKING,D.TSHIPPER_FK,F.NAMAPERUSAHAAN,D.TEXPORTCONTAINER_FK,G.NAMAPELABUHAN,H.NAMANEGARA FROM tworkordermastertarifcargo A LEFT OUTER JOIN tworkordertarifcargo B ON A.TWORKORDER_FK=B.TWORKORDER_PK LEFT OUTER JOIN tconsolidator C ON A.TCONSOLIDATOR_FK=C.TCONSOLIDATOR_PK LEFT OUTER JOIN tworkorderdetailtarifcargo D ON B.TWORKORDER_PK=D.TWORKORDER_FK LEFT OUTER JOIN tpacking E ON D.TPACKING_FK=E.TPACKING_PK LEFT OUTER JOIN tperusahaan F ON D.TSHIPPER_FK=F.TPERUSAHAAN_PK LEFT OUTER JOIN tpelabuhan G ON D.TPELABUHAN_FK=G.TPELABUHAN_PK LEFT OUTER JOIN tnegara H ON D.TNEGARA_FK=H.TNEGARA_PK Where A.NOCARGO = ''