select a.* ,b.HandBookNo,c.ProdAb,b.sinper,b.sinflag,b.matcaseno<br>from Ciq_ProUllageMan a left join Ciq_MaterialMan b on a.PactNo=b.PactNo and a.materialname=b.materialname<br>left join Ciq_ProductMan c on a.PactNo=c.PactNo and a.productname=c.productname<br>where 1=1 and ...<br>更新时只更新表Ciq_ProUllageMan