select a.BUYER_COM_CD,
TM_ORDERCORPMST.BUYER_COM_NAME
from oj TM_ORDERCORPMST ,TM_CONNECTMST a
where TM_ORDERCORPMST.BUYER_COM_CD = a.BUYER_COM_CD(+)
and COM_CONTROL_CD (+)= 'CW000184'
and TM_ORDERCORPMST.DELETE_DATE IS NULL
and TM_ORDERCORPMST.DELETE_USER IS NULL
TM_ORDERCORPMST.BUYER_COM_NAME
from oj TM_ORDERCORPMST ,TM_CONNECTMST a
where TM_ORDERCORPMST.BUYER_COM_CD = a.BUYER_COM_CD(+)
and COM_CONTROL_CD (+)= 'CW000184'
and TM_ORDERCORPMST.DELETE_DATE IS NULL
and TM_ORDERCORPMST.DELETE_USER IS NULL
SELECT a.BUYER_COM_CD,TM_ORDERCORPMST.BUYER_COM_NAME
FROM TM_ORDERCORPMST LEFT OUTER JOIN
(select * from TM_CONNECTMST where COM_CONTROL_CD = 'CW000184') a ON TM_ORDERCORPMST.BUYER_COM_CD = a.BUYER_COM_CD
WHERE (TM_ORDERCORPMST.DELETE_DATE IS NULL) AND (TM_ORDERCORPMST.DELETE_USER IS NULL)
SELECT a.BUYER_COM_CD,TM_ORDERCORPMST.BUYER_COM_NAME
FROM oj TM_ORDERCORPMST LEFT OUTER JOIN
(select * from TM_CONNECTMST where COM_CONTROL_CD = 'CW000184') a ON TM_ORDERCORPMST.BUYER_COM_CD = a.BUYER_COM_CD WHERE TM_ORDERCORPMST.DELETE_DATE IS NULL AND TM_ORDERCORPMST.DELETE_USER IS NULL