Can "NOT IN" be expressed in a single block query? - Database版

本页内容为未名空间相应帖子的节选和存档，一周内的贴子最多显示50字，超过一周显示500字访问原贴

Database版 - Can "NOT IN" be expressed in a single block query?

相关主题
● 请教一个query	● 关于Acess的简单问题
● question on nested query	● 一个SQL query的问题
● 有什么优化query的常用方法	● Question 2: distributed database question?
● [转载] ASP问题： Operation must use an updateable query	● [转载] question about SQL in Access
● Help: "Operation Must Be Updatable Query"	● [转载] Can anyone interpret this simple SQL?
● Undefined function 'Date' in Expression	● A sql question
● 问一个query，about Recursive Queries Using Common Table Expressions	● how to make query faster?
● "express" version的数据库，是不是sql server express最好？	● query estimation shows cost 900%?

相关话题的讨论汇总
话题: query话题: expressed话题: block话题: single话题: where

进入Database版参与讨论

(共1页)

t**********s
发帖数: 930

I am reading FUNDAMENTALS OF DATABASE SYSTEMS where it says "In general, a
query written with nested SELECT...FROM...WHERE... blocks and using = or IN
comparison operators can always be expressed as a single block query."
I believe this is true.
Now I wonder whether similar structure with 'NOT IN' comparison operator
can be expressed as a single block query.
Can any body give me an example?

(共1页)

进入Database版参与讨论

相关主题
● query estimation shows cost 900%?	● Help: "Operation Must Be Updatable Query"
● oracle JDBC thin vs. JDBC OCI	● Undefined function 'Date' in Expression
● 再问个excel问题吧	● 问一个query，about Recursive Queries Using Common Table Expressions
● 急，SQL2005, 怎么查过去一小时里run过的所有query?	● "express" version的数据库，是不是sql server express最好？
● 请教一个query	● 关于Acess的简单问题
● question on nested query	● 一个SQL query的问题
● 有什么优化query的常用方法	● Question 2: distributed database question?
● [转载] ASP问题： Operation must use an updateable query	● [转载] question about SQL in Access

相关话题的讨论汇总
话题: query话题: expressed话题: block话题: single话题: where

#	版面	帖数(主题数)
-	全站	4871 (796)
1	Military	3777 (569)
2	Stock	341 (51)
3	Joke	117 (17)
4	History	116 (3)
5	Automobile	100 (9)
6	USANews	55 (9)
7	Midlife	45 (1)
8	Headline	41 (41)
9	Dreamer	33 (13)
10	FleaMarket	32 (20)
11	Living	30 (7)

boards

未名新帖统计// 7月16日

历史上的今天