常用SQL语句001

易飞9.0_SQL语句

查询和更改工单主件品号规格

select TA035,* from MOCTA WHERE TA002='2108280037' AND TA001='5102'

UPDATE MOCTA SET TA035='RAL3000,软皮黑色,ROHS环保,PA6-GF30' WHERE TA002='2108280037' AND TA001='5102'

查询和删除进货单

select * from PURTG where TG001='3401' AND TG002='20211101025'

DELETE from PURTG where TG001='3401' AND TG002='20211101025'

查询和更改进货单计价数量

SELECT * FROM PURTH WHERE TH002='20211021005' AND TH003='0004' 

UPDATE PURTH SET TH016='400' WHERE TH002='20211021005' AND TH003='0004'