SQL Server Update with Inner Join - Stack Overflow

2010年8月12日 - tblOrder(OrderId INT) tblVariety(VarietyId INT,Stock INT) ... My guess is that because you have shown us simplified schema, some info is missing ...

stackoverflow.com