常用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='20211
原创
2021-12-06 19:26:38 ·
576 阅读 ·
0 评论