/* Formatted on 2007/07/30 08:05 (Formatter Plus v4.8.7) */
SELECT entity_no, dfct_code
FROM mcsda1.mcshis_defectcode @dblkpnbrw3
WHERE entity_no IN (
SELECT DISTINCT entity_no
FROM mcrda1.wp_pnlhist
WHERE fac_id = ' C '
AND trans_date >= ' 2007-07-28 02.01.51.000000 '
AND trans_date <= ' 2007-07-28 02.42.42.229473 ' )
SELECT entity_no, dfct_code
FROM mcsda1.mcshis_defectcode @dblkpnbrw3
WHERE entity_no IN (
SELECT DISTINCT entity_no
FROM mcrda1.wp_pnlhist
WHERE fac_id = ' C '
AND trans_date >= ' 2007-07-28 02.01.51.000000 '
AND trans_date <= ' 2007-07-28 02.42.42.229473 ' )
以上SQL IN 部分中 entity_no 栏位不存在(应该为 pnl_id ), 但是在查询的时候系统并不报错, 值为NULL , 造成查询结果为 mcsda1.mcshis_defectcode @dblkpnbrw3 中所有 entity_no & dfct_code