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 该怎样写? 谢谢!
=======================================================================
SQL中执行正常,,
ACCESS中错误:子查询 'cCaption' 中 Memo 或 OLE 对象无效.请问什么原因,,
如果换成LEFT JOIN 该怎样写? 谢谢!
效果一样
and cCaption Not in
(Select Distinct cCaption From DictSetup Where cBillName='支票' and cObjType='Text')这样ACCESS不支持>
and cCaption Not in
(Select Distinct cCaption From DictSetup Where cBillName='支票' and cObjType='Text'
AND cCaption IS NOT NULL)Select * From DictField D
Where cBillName='支票'
and NOT EXISTS(Select 1 From DictSetup Where cBillName='支票' and cObjType='Text' AND cCaption =D.cCaption )
Select
*
From
DictField
Where
cBillName='支票'
and
cCaption
Not in (Select Distinct cCaption From DictSetup Where cBillName='支票' and cObjType='Text')