杀了M$, sql server and access 的SQL exists子句语法差这么远 (50分)

仅返回所有子类别
1。
sql server OK
access all record
BCB+BDE+access all record
SELECT * FROM aaa AS a WHERE not exists (select * from aaa b where b.类别编号 like a.类别编号+'_%')

2。
sql server all record
access OK
BCB+BDE+access ERROR
SELECT * FROM aaa AS a WHERE not exists (select * from aaa b where b.类别编号 like a.类别编号+'?*')

3。
sql server all record
access OK
BCB+BDE+access OK
SELECT * FROM aaa a WHERE 2>(select count(*) from aaa b where b.类别编号 like a.类别编号+'*')

在BCB+BDE+access用格式2（即exists） like后面如何写
（Local SQL 的like是格式1。）

好象应该是like 'aaa%'这种格式吧?

Iknow
you don't know what "-" mean? or you didn't see it?

bde and ado 的* ? % 是有点区别

no one can answer

接受答案了.