使用嵌套的SELECT访问INSERT

本文介绍了使用嵌套的SELECT访问INSERT的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

为什么以下SQL语句不起作用?

Why does the following SQL statement not work?

INSERT INTO dialog (speaker, dialog_text) VALUES ( ( SELECT FIRST(id) FROM FIGURE WHERE char_name="Doe" AND forename="John" ), "Some text" );

它会产生此错误:

查询输入必须至少包含一个表或查询.

Query input must contain at least one table or query.

单个SELECT语句有效.

推荐答案

Access SQL INSERT ... VALUES语句不允许您对VALUES

An Access SQL INSERT ... VALUES statement will not let you use a subquery for one of the VALUES

像Piotr 建议一样，切换到INSERT ... SELECT语句即可.

Switching to an INSERT ... SELECT statement, as Piotr suggested will work.

或者您可以使用访问权限域聚集函数，而不是子查询，在您的INSERT ... VALUES语句中:

Or you could use an Access Domain Aggregate function, instead of a subquery, in your INSERT ... VALUES statement:

INSERT INTO dialog (speaker, dialog_text) VALUES ( DMin("id", "FIGURE", "char_name='Doe' AND forename='John'"), 'Some text' );