SELECT d.ID,d.COMPANY,d.CDATE,d.AMOUNT,d.CLASS,d.INITIATOR,d.RANK,d.UNIT,d.STAFF,d.DEPARTMENT,d.DESCRIBE,d.EXPLAIN,d.REMARK,d.TBTIME

FROM INPUT_SA_CHECK d WHERE d.rank in (select a.rank from INPUT_SA_CHECK A,BASE_DICTIONARY b where b.itemcode1='SA01')

and d.class in 

(select a.class from INPUT_SA_CHECK A,BASE_DICTIONARY c where c.itemcode1='SA02')

单纯靠「ITEMCODE2」字段关联，确定业务逻辑正常？

——————————————

SELECT

A.ID,

A.COMPANY,

A.CDATE,

A.AMOUNT,

B2.ITEMNAME2 CLASS,

A.INITIATOR,

B1.ITEMNAME2 RANK,

A.UNIT,

A.STAFF,

A.DEPARTMENT,

A.DESCRIBE,

A.EXPLAIN,

A.REMARK,

A.TBTIME

FROM

INPUT_SA_CHECK A

LEFT JOIN BASE_DICTIONARY B1 

ON to_char(A.RANK) = B1.ITEMCODE2 or to_char(A.CLASS) = B2.ITEMCODE2

————————————————————