使用嵌套的SELECT访问INSERT [英] Access INSERT with nested SELECT

问题描述

为什么以下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'
);

这篇关于使用嵌套的SELECT访问INSERT的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！