SQL语句不能再ACCESS种执行，，NOT IN

Select * from DictField Where cBillName='支票' and Not cCaption  in (Select Distinct cCaption from DictSetup Where cBillName='支票' and cObjType='Text')
=======================================================================
SQL中执行正常，，
ACCESS中错误：子查询 'cCaption' 中 Memo 或 OLE 对象无效.

请问什么原因，，
如果换成LEFT JOIN 该怎样写？ 谢谢！

---

Select * from DictField Where cBillName='支票' and cCaption Not in (Select Distinct cCaption from DictSetup Where cBillName='支票' and cObjType='Text')
效果一样

---

SQL code:
Select * from DictField Where cBillName='支票'
and cCaption Not in
(Select Distinct cCaption from DictSetup Where cBillName='支票' and cObjType='Text')


这样ACCESS不支持>

---

Select * from DictField Where cBillName='支票' and  cCaption Not in (Select Distinct cCaption from DictSetup Where cBillName='支票' and cObjType='Text')

换下位置！

---

SQL code:
---try
Select
*
from
DictField
Where
cBillName='支票'
and
cCaption
Not in (Select Distinct cCaption from DictSetup Where cBillName='支票' and cObjType='Text')

{{