一个SQL语句问题请教,在线等待!!
我现在只要把HistoryXSJ2003.dbo.工艺表里面的铝框尺寸用powermangerback.dbo.AluminiumFrame里面
Standard_ID代替,
条件是:powermangerback.dbo.AluminiumFrame.Standard_Size= HistoryXSJ2003.dbo.工艺表.铝框尺寸
请问怎么写阿
为什么我这样写不行:
update HistoryXSJ2003.dbo.工艺表
set 铝框尺寸=(select Standard_ID
from powermangerback.dbo.AluminiumFrame,HistoryXSJ2003.dbo.工艺表
where powermangerback.dbo.AluminiumFrame.Standard_Size= HistoryXSJ2003.dbo.工艺表.铝框尺寸)
where powermangerback.dbo.AluminiumFrame.Standard_Size= HistoryXSJ2003.dbo.工艺表.铝框尺寸