本文介绍了使用内部联接删除查询时出错的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

以下是我试图运行的查询:


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

推荐答案




这篇关于使用内部联接删除查询时出错的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-20 10:59
查看更多