use hbposv8
go
update t_bd_item_info set item_sup_flag=t_bd_supcust_info.sale_way from t_bd_item_info,t_bd_supcust_info
where t_bd_item_info.main_supcust=t_bd_supcust_info.supcust_no
and t_bd_item_info.item_sup_flag<>t_bd_supcust_info.sale_way

update t_pc_branch_price set t_pc_branch_price.sale_way=t_bd_supcust_item.sale_way from t_bd_supcust_item ,t_pc_branch_price where 
t_pc_branch_price.item_no=t_bd_supcust_item.item_no
and t_pc_branch_price.branch_no=t_bd_supcust_item.branch_no
go