SELECT item_clsno,* FROM t_bd_item_info
WHERE item_clsno not IN (SELECT item_clsno FROM t_bd_item_cls)
update t_bd_item_info set item_clsno='00' where item_clsno not IN (SELECT item_clsno FROM t_bd_item_cls )
----查询商品档案里面供应商不在供应商表里面的数据信息 SELECT main_supcust,* FROM t_bd_item_info
WHERE main_supcust not IN (SELECT supcust_no FROM t_bd_supcust_info where supcust_flag='s' )
update t_bd_item_info set main_supcust='01' where main_supcust not IN (SELECT supcust_no FROM t_bd_supcust_info where supcust_flag='s' )