SELECT *
--UPDATE ICSTOCKBILL SET FHOOKSTATUS=''
from ICStockBill v1 INNER JOIN ICStockBillEntry u1 ON v1.FInterID = u1.FInterID AND u1.FInterID <>0
INNER JOIN t_Supplier t4 ON v1.FSupplyID = t4.FItemID AND t4.FItemID <>0
INNER JOIN t_ICItem t13 ON u1.FItemID = t13.FItemID AND t13.FItemID <>0
INNER JOIN t_MeasureUnit t30 ON t13.FUnitID = t30.FItemID AND t30.FItemID <>0
LEFT OUTER JOIN t_MeasureUnit t500 ON t13.FStoreUnitID = t500.FItemID AND t500.FItemID <>0
LEFT OUTER JOIN t_SonCompany t560 ON v1.FBrID = t560.FItemID AND t560.FItemID <>0
where 1=1 AND (
ISNULL(t4.FNumber,'') = '021642'
) AND (v1.FTranType=1 AND ((v1.FCheckerID>0) and v1.FROB=1 and v1.FCancellation = 0))
and fbillno=
--参数,订单号
--'WIN001358'
--'WIN001219'
--'WIN002465'
--'WIN001329'
-----------------------------------------------------------