问题描述
以下是我试图运行的查询:
DELETE DISTINCTROW设备。*
来自CHSRRequestInProgressB INNER JOIN设备ON CHSRRequestInProgressB.JTag =设备。[EquipJ-tag#];
我收到一条错误,指出无法从指定的表中删除。我需要删除的行的表在Equipment表中。 [EquipJ-tag#]是此表中的主键。我可以在设备表本身内进行编辑,因此该表不是只读的。我可以在数据表视图中运行查询,信息是正确的,但我无法更新信息。
请协助。
Rick
Below is the query that I am attempting to run:
DELETE DISTINCTROW Equipment.*
FROM CHSRRequestInProgressB INNER JOIN Equipment ON CHSRRequestInProgressB.JTag = Equipment.[EquipJ-tag#];
I receive an error stating "Could not delete from specified tables". The table I need the rows deleted from are in the Equipment table. The "[EquipJ-tag#]" is the primary key in this table. I can edit from within the equipment table itself, so the table is not read only. I can run the query in datasheet view and the information is correct, but I can not update the information.
Please assist.
Rick
推荐答案
这篇关于使用内部联接删除查询时出错的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!