SQL缺少更新或刷新键列信息

更新两个连接表的视图时出现此错误
谢谢学哥学姐们!
SELECT B.ID, A.Fdate AS 日期, A.Fbb AS 班别, cx.BNAME AS 车型, zhd.BNAME AS 装货地,
B.Fzpiao AS 装票数, B.Fzprice AS 装地价, xhd.BNAME AS 卸货地,
B.Fxpiao AS 卸票数, B.Fxprice AS 卸地价, hw.BNAME AS 货物, B.Fnum AS 数量,
dw.BNAME AS 单位
FROM dbo.XCDZ A INNER JOIN
dbo.XCDF B ON A.IDN = B.IDN LEFT OUTER JOIN
dbo.shebei sb ON sb.ID = A.Fcarno LEFT OUTER JOIN
dbo.cartype cx ON cx.ID = sb.CXID LEFT OUTER JOIN
dbo.gongdi zhd ON zhd.ID = B.Fzaddr LEFT OUTER JOIN
dbo.gongdi xhd ON xhd.ID = B.Fxaddr LEFT OUTER JOIN
dbo.goods hw ON hw.ID = B.Fgoods LEFT OUTER JOIN
dbo.danwei dw ON dw.ID = B.Fdw
视图中ID列在表XCDF中是主键

SQL缺少更新或刷新键列信息 sql server键列信息不足或不正确。更新影响到过多的行。 用SQL Server 2000 把表里的值从NULL改为其他时提示“键列信息不足或不正确。更新影响到多行。”该怎么办 如何更改或刷新blos信息 SQL事务处理怎么不能更新两条信息？ SQL中如何update把表2的三列数据更新到表1 提示我“SQL: 缺少GROUP BY 子句或子句无效” 请问是为什么？？ SQL数据库中如何在一个列下存储一组信息 刷新无更新 sql 获取列名