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" 發(fā)表：
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

哦。。原來是醬紫。
謝謝