您所在位置：主题：SQL语句弱弱的问
cnhawk386
[专家分：0] 发布于 2006-06-13 13:23:00
update a set id3=isnull(a.id3,b.id3),id2=isnull(a.id2,b.id2),id4=isnull(a.id4,b.id4)
from openrowset('microsoft.jet.oledb.4.0',';database=C:\ziliao\database\product.mdb','select * from product') a inner join product b on a.id1=b.id1 where (a.id3 is null or a.id2 is null or a.id4 is null)
错误提示为：对象名 'a' 无效。
from openrowset('microsoft.jet.oledb.4.0',';database=C:\ziliao\database\product.mdb','select * from product') a inner join product b on a.id1=b.id1 where (a.id3 is null or a.id2 is null or a.id4 is null)
错误提示为：对象名 'a' 无效。
