由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - error of sql query in MS Access database (转载)
相关主题
请问个join的问题咋样选一个表中在另一个表中不含有的记录
Help: "Operation Must Be Updatable Query"急问Access Query问题:怎样查询最后一个非空的数值,谢谢
问个 sp_send_dbmail 的问题How to Import a Datatable as fast as possible?
SQL combine two tables into one table and add a new column紧急求助, 关于SQL Server
菜鸟问题,急请教一个sql问题
how to write this querysql数据库实时更新问题
Error of SQL query on IBM netezza SQL database from Aginity (转载)change year format in Access by SQL query (转载)
SQL 查询已经解决.谢谢Modeler,mirthc,cheungcheSQL question...
相关话题的讨论汇总
话题: select话题: access话题: ms话题: where话题: query
进入Database版参与讨论
1 (共1页)
l******9
发帖数: 579
1
【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: error of sql query in MS Access database
发信站: BBS 未名空间站 (Wed Oct 15 17:38:15 2014, 美东)
I need to do a sql query in MS Access 2012.
But I got error in MS Access:
SELECT *
FROM
(
SELECT *
FROM table1
where not exists
(
SELECT *
FROM table2
where table2.id = table1.id
) as t
) as t1, table3
where table3.id = t1.id
Syntax error: (missing operator) in query expression 'not exists ( ... ) as
t'
Any help would be appreciated.
c*****d
发帖数: 6045
2
SELECT *
FROM
(
SELECT *
FROM table1
where not exists
(
SELECT *
FROM table2
where table2.id = table1.id
)
) as t1, table3
where table3.id = t1.id
1 (共1页)
进入Database版参与讨论
相关主题
SQL question...菜鸟问题,急
A sql questionhow to write this query
query estimation shows cost 900%?Error of SQL query on IBM netezza SQL database from Aginity (转载)
请问这个query怎么做SQL 查询已经解决.谢谢Modeler,mirthc,cheungche
请问个join的问题咋样选一个表中在另一个表中不含有的记录
Help: "Operation Must Be Updatable Query"急问Access Query问题:怎样查询最后一个非空的数值,谢谢
问个 sp_send_dbmail 的问题How to Import a Datatable as fast as possible?
SQL combine two tables into one table and add a new column紧急求助, 关于SQL Server
相关话题的讨论汇总
话题: select话题: access话题: ms话题: where话题: query