SQL 查询 ，无法识别"("选择

Question

select * 
from TABLE_A 
where ID = (select ID 
from TABLE_B as b 
inner join TABLE_C as c on b.id = c.id 
where b.date = "2021-10-31");

无法识别'(' 'select' 'ID' ')附近的输入

Answer 1

您的查询有更正。

由于内部选择查询将返回id集合，因此您需要使用'in'关键字而不是'='。

修改后，你的查询应该是这样的:

select * from TABLE_A where ID in (select ID from TABLE_B as b inner join TABLE_C as c on b.id = c.id where b.date = "2021-10-31");