9。3不可以用此语句

carefen

在9。4可以运行以下语句，在9 。3却不可以。晕
select count(*) from b cross join a where (b.b1 between a.a1 and a.a2);

carefen

以上的语句是查找出b表在a表的数据。
能否查出b表不在a表的数据呢。
我用了这句，语法错误
select * from b cross join a where not exists (b.b1 between a.a1 and a.a2);

lmtok

select * from b where not exists
(select 1 from a where b.b1 between a.a1 and a.a2);
just 44

carefen

原帖由 "lmtok" 发表：
select * from b where not exists
(select 1 from a where b.b1 between a.a1 and a.a2);
just 44

select 1 from a
请问
select 1 是什么意思呢？

lmtok

没有什么含义，只表示true or false

carefen

哦。。原来是酱紫。
谢谢