基于Access中已保存的SELECT查询的UPDATE查询? [英] UPDATE query based on a saved SELECT query in Access?

问题描述

使用UPDATE查询，是否可以引用存储的选择查询?

Using a UPDATE query, is it possible to reference to a stored select query?

我想完成这样的事情:

UPDATE ... WHERE ... IN [MY_STORED_PROCEDURE]

推荐答案

也许在这些行上有一些东西:

Perhaps something on these lines:

UPDATE ...
WHERE ID IN (SELECT ID FROM MyStoredProc)

根据您的设置，也可能可以加入.您可以将存储的查询添加到查询设计窗口中，但并非总是以可更新的查询结尾，通常取决于您的索引.

Depending on your set up, a join may also be possible. You can add stored queries to the query design window, but you do not always end up with an updatable query, it usually depends on your indexes.

这篇关于基于Access中已保存的SELECT查询的UPDATE查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！