由于Null Value数据未重新引用

请改用左联接。即使没有关联方的数据，左联接也不会严格，并且仍会显示。

select distinct   vsor.shipment_gid,  vsor.order_release_gid,  orem1.remark_text as Related_Party,  orem2.remark_text as ULTIMATE_CONSIGNEE_TYPE,  orem3.remark_text as CONSIGNEE_TYPEfrom view_shipment_order_release vsorLEFT JOIN  order_release_remark orem1ON  orem1.REMARK_QUAL_GID ='GECORP.ConSIGNEE TYPE' and orem1.order_release_gid=vsor.order_release_gid  LEFT JOIN order_release_remark orem2  ON orem2.REMARK_QUAL_GID ='GECORP.RELATED PARTY'    and orem2.order_release_gid=vsor.order_release_gid  LEFT JOIN order_release_remark orem3  ON orem3.REMARK_QUAL_GID ='GECORP.ULTIMATE ConSIGNEE TYPE'and orem3.order_release_gid=vsor.order_release_gidwhere vsor.shipment_gid='GECORP.101027274';