join on后面的条件必须是定义连接关系的条件,其他条件不生效,其他条件应该放在where后面 例如: select * from PRODUCT_SUBJECT_GROUP_TEMP WHERE CHECK_STATUS = 'CHECKING') h left join BOOK b on b.BOOK_CODE = h.BOOK_CODE AND b.TRUST_MGR_CODE IN ('ZXXT')
中的 AND b.TRUST_MGR_CODE IN ('ZXXT') 根本不起作用。
应该写成:
select *
from PRODUCT_SUBJECT_GROUP_TEMP WHERE CHECK_STATUS = 'CHECKING') h left join BOOK b on b.BOOK_CODE = h.BOOK_CODE
where b.TRUST_MGR_CODE IN ('ZXXT')