oracle 笛卡尔积 左右连接

select bwf.BWFR_ID,bwf.BWFR_SUBCLASS,bwf.BWFR_CONSIGN_ID,bwf.BWFR_SRC_CONSIGN_ID,
bwf.BWFR_COMPLETE_TIME,bwf.BWFR_CUSTOMER,bwf.BWFR_CANVASS,bwf.BWFR_FLOW,bwf.BWFR_SERV_SEGMENT,
bwf.BWFR_MBL_NO,bwf.BWFR_HBL_NO,bwf.BWFR_VESSEL_EN,bwf.BWFR_VOYAGE_CODE,bwf.BWFR_SAILING_TIME,
bwf.BWFR_DELIVER_TIME,bwf.BWFR_FEEDER_CARRIER,bwf.BWFR_CARRIER,bwf.BWFR_LOADING_PORT,
bwf.BWFR_TRANSFER_PORT,bwf.BWFR_DISCHARGE_PORT,bwf.BWFR_OVERSEA_AGENT,bwf.BWFR_PAY_MODE,
bwf.BWFR_TERM,bwf.BWFR_BULK_VOLUME,bwf.BWFR_LCL_VOLUME,bwf.BWFR_TEU,bwf.BWFR_CUSTOMS_NUM,
bwf.BWFR_REMARK,bwf.BWFR_ORG_ID,bwf.BWFR_AUDIT_FLAG,bwf.BWFR_DEL_FLAG,bwf.MODIFY_TIME,bwf.MODIFIER,
bwf.CREATE_TIME,bwf.CREATOR,bwf.REC_VER,
ccu.CCUS_NAME,cfc.CFCA_NAME,cca.CCAR_NAME,csp.CSPO_NAME "BWFR_LOADING_PORT_NAME",
csp2.CSPO_NAME "BWFR_TRANSFER_PORT_NAME",csp3.CSPO_NAME "BWFR_DISCHARGE_PORT_NAME" ,
coa.COAG_NAME
from bus_waterway_freight bwf , cod_customer ccu , cod_shipping_port csp , cod_feeder_carrier cfc , cod_carrier cca
, cod_shipping_port csp2 , cod_shipping_port csp3 , COD_OVERSEA_AGENT coa
where bwf.BWFR_DEL_FLAG ='N'
and bwf.BWFR_ID = :bwfrId
and bwf.BWFR_CUSTOMER = ccu.ccus_Id(+)
and bwf.BWFR_CARRIER = cca.ccar_Id(+)
and bwf.BWFR_FEEDER_CARRIER = cfc.cfca_Id(+)
and bwf.BWFR_LOADING_PORT = csp.cspo_Id(+)
and bwf.BWFR_TRANSFER_PORT = csp2.cspo_Id(+)
and bwf.BWFR_DISCHARGE_PORT = csp3.cspo_Id(+)
and bwf.BWFR_OVERSEA_AGENT = coa.coag_Id(+)


-----------------------------------------------------------------

select bwf.BWFR_ID,bwf.BWFR_SUBCLASS,bwf.BWFR_CONSIGN_ID,bwf.BWFR_SRC_CONSIGN_ID,
bwf.BWFR_COMPLETE_TIME,bwf.BWFR_CUSTOMER,bwf.BWFR_CANVASS,bwf.BWFR_FLOW,bwf.BWFR_SERV_SEGMENT,
bwf.BWFR_MBL_NO,bwf.BWFR_HBL_NO,bwf.BWFR_VESSEL_EN,bwf.BWFR_VOYAGE_CODE,bwf.BWFR_SAILING_TIME,
bwf.BWFR_DELIVER_TIME,bwf.BWFR_FEEDER_CARRIER,bwf.BWFR_CARRIER,bwf.BWFR_LOADING_PORT,
bwf.BWFR_TRANSFER_PORT,bwf.BWFR_DISCHARGE_PORT,bwf.BWFR_OVERSEA_AGENT,bwf.BWFR_PAY_MODE,
bwf.BWFR_TERM,bwf.BWFR_BULK_VOLUME,bwf.BWFR_LCL_VOLUME,bwf.BWFR_TEU,bwf.BWFR_CUSTOMS_NUM,
bwf.BWFR_REMARK,bwf.BWFR_ORG_ID,bwf.BWFR_AUDIT_FLAG,bwf.BWFR_DEL_FLAG,bwf.MODIFY_TIME,bwf.MODIFIER,
bwf.CREATE_TIME,bwf.CREATOR,bwf.REC_VER,bwf.BWFR_INPUT_MODE,
ccu.CCUS_NAME,cfc.CFCA_NAME,cca.CCAR_NAME,csp.CSPO_NAME "BWFR_LOADING_PORT_NAME",
csp2.CSPO_NAME "BWFR_TRANSFER_PORT_NAME",csp3.CSPO_NAME "BWFR_DISCHARGE_PORT_NAME" ,
coa.COAG_NAME
from bus_waterway_freight bwf left outer join cod_customer ccu on bwf.BWFR_CUSTOMER = ccu.ccus_Id
left outer join cod_feeder_carrier cfc on bwf.BWFR_FEEDER_CARRIER = cfc.cfca_Id
left outer join cod_carrier cca on bwf.BWFR_CARRIER = cca.ccar_Id
left outer join cod_shipping_port csp on bwf.BWFR_LOADING_PORT = csp.cspo_Id
left outer join cod_shipping_port csp2 on bwf.BWFR_TRANSFER_PORT = csp2.cspo_Id
left outer join cod_shipping_port csp3 on bwf.BWFR_DISCHARGE_PORT = csp3.cspo_Id
left outer join COD_OVERSEA_AGENT coa on bwf.BWFR_OVERSEA_AGENT = coa.coag_Id
where bwf.BWFR_DEL_FLAG ='N'
and bwf.BWFR_ID = :bwfrId