SELECT a.QUALIFY_ID, a.IS_PASS, b.QUALIFY_NAME, b.FILE_NAME, b.FILE_REQUIRE, c.TART_DATE, c.END_DATE
FROM TBL_EVA_QUALIFY b,TBL_COR_QUALIFY_BASE c,TBL_AUDIT_BIDDER a
WHERE a.QUALIFY_ID = '221' AND a.ORGAN_ID = 'jk111111-4' AND a.PREQUALIFY_FLAG = '1'
AND b.QUATYPE_ID = c.QUALIFY_ID
AND c.QUALIFY_ID(+) = a.QUALIFY_ID
AND c.ORGAN_ID(+) = a.ORGAN_ID
FROM TBL_EVA_QUALIFY b,TBL_COR_QUALIFY_BASE c,TBL_AUDIT_BIDDER a
WHERE a.QUALIFY_ID = '221' AND a.ORGAN_ID = 'jk111111-4' AND a.PREQUALIFY_FLAG = '1'
AND b.QUATYPE_ID = c.QUALIFY_ID
AND c.QUALIFY_ID(+) = a.QUALIFY_ID
AND c.ORGAN_ID(+) = a.ORGAN_ID
FROM dbo.TBL_EVA_QUALIFY b INNER JOIN
dbo.TBL_COR_QUALIFY_BASE c ON
b.QUATYPE_ID = c.QUALIFY_ID RIGHT OUTER JOIN
dbo.TBL_AUDIT_BIDDER a ON
(c.QUALIFY_ID = a.QUALIFY_ID AND c.ORGAN_ID = a.ORGAN_ID
WHERE a.QUALIFY_ID = '221'
AND a.ORGAN_ID = 'jk111111-4'
AND a.PREQUALIFY_FLAG = '1')
FROM dbo.TBL_EVA_QUALIFY b INNER JOIN
dbo.TBL_COR_QUALIFY_BASE c ON
(b.QUATYPE_ID = c.QUALIFY_ID RIGHT OUTER JOIN
dbo.TBL_AUDIT_BIDDER a ON
(c.QUALIFY_ID = a.QUALIFY_ID AND c.ORGAN_ID = a.ORGAN_ID
WHERE a.QUALIFY_ID = '221'
AND a.ORGAN_ID = 'jk111111-4'
AND a.PREQUALIFY_FLAG = '1'))