修改客户代号：

SELECT * FROM COPTG WHERE TG002='20120058'

UPDATE COPTG SET TG007=MA003,TG008=MA023,TG018=MA023 FROM COPMA WHERE TG004=MA001 AND TG002='20120058'

SELECT * FROM COPMA WHERE MA001='142'

UPDATE COPTG SET TG004='客户代号' WHERE TG001='2399' AND TG002='20120058'


UPDATE COPTG SET TG007=MA003,TG008=MA023,TG018=MA023 FROM COPMA WHERE TG004=MA001 AND TG001='2399' AND TG002='20120058'



select * from ordreb where taskid=1055 and gridorder=1  查询表名为ordreb  条件为单号为1055 

update ORDREB set TB001='1.217.02.01.01.0025'
 where taskid=1055 and gridorder=2
 
 
 
 select * from proofb where taskid=969
 update proofb set DW='米'
 where taskid=969 and gridorder=1