从表AA （+） = 主表BB
SELECT TO_CHAR(TBAFBS_IO_DATEYYYY/MM/DD) A TBATBA_TBD_NO A TBBTBB_NAME_S A TBCTBC_CHAR A TBDTBD_NAME A TBATBA_SNS_NAME_SP A TBATBA_TORI_KIN A TO_CHAR(TBATBA_RPL_DATEYYYY/MM/DD) A FROM SNTBATRN TBA ZMTBCMST TBC CMTBBMST TBB CMTBDMST TBD WHERE TBATBA_KAI_CODE = XXX AND TBATBA_KESHI_KBN = AND TBATBA_TAISYO_KBN IN ( ) AND TBB_KAI_CODE (+) = XXX AND TBB_BUN_CODE (+) = S AND TBB_START_DATE <= SYSDATE AND TBB_END_DATE >= SYSDATE AND TBBTBB_CODE (+)= TBATBA_STN_CODE AND TBCTBC_KAI_CODE (+) = XXX AND TBCTBC_SUB_KBN (+) = SN AND TBDTBD_KAI_CODE (+) = XXX AND TBDTBD_CODE (+) = TBATBA_SNS_CODE
主表AA = 从表BB （+）
SELECT TBATBA_ TBBTBB_ TBCTBC_FROM TBA (SELECT TBBTBB_ TBBTBB_ FROM TBB WHERE TBBTBB_ LIKE %NEWWEAPON% TBB) TBCWHERE //主表TBC TBATBA_A > //从表TBB AND TBATBA_ = TBBTBB_ //从表TBC //注意TRIM AND TRIM(TBATBA_) = TRIM(TBCTBC_ (+))
