我的代码(SQL)SQL="select * from hntCLAll left join HntCLDetail on (hntCLAll.hntCLAll_id=HntCLDetail.HntCLDetail_code) left join HntCailiao on (hntCLAll.hntCLAll_cailiao=HntCailiao.HntCailiao_id) where hntCLAll.hntCLAll_type=3 and order by hntCLAll.hntCLAll_id desc"RstTemp.Open SQL, HntConn, 3, 2, adCmdText(ADO2.6)错误: 实时错误'-2147217900(80040e14)'语法错误(操作符丢失)在查询表达式 '(hntCLAll.hntCLAll_id=HntCLDetail.HntCLDetail_code) left join HntCailiao on (hntCLAll.hntCLAll_cailiao=HntCailiao.HntCailiao_id)'
当然支持,不过你写的语句不是access的left join 语句,看下面的例子: SELECT AUC_SEQ.SEQTIME, AUC_SEQ.SEQADD, AUC_SEQ.CURRENTB FROM ((AUC_SEQ LEFT JOIN AUC_TBL ON AUC_SEQ.SEQNO = AUC_TBL.seqno) LEFT JOIN CARD_DETAIL_TBL ON AUC_TBL.seqno = CARD_DETAIL_TBL.[NO]) LEFT JOIN CARD_TBL ON AUC_SEQ.SEQNO = CARD_TBL.SEQNO;
实时错误'-2147217900(80040e14)'语法错误(操作符丢失)在查询表达式
'(hntCLAll.hntCLAll_id=HntCLDetail.HntCLDetail_code) left join HntCailiao on (hntCLAll.hntCLAll_cailiao=HntCailiao.HntCailiao_id)'
SELECT AUC_SEQ.SEQTIME, AUC_SEQ.SEQADD, AUC_SEQ.CURRENTB
FROM ((AUC_SEQ LEFT JOIN AUC_TBL ON AUC_SEQ.SEQNO = AUC_TBL.seqno) LEFT JOIN CARD_DETAIL_TBL ON AUC_TBL.seqno = CARD_DETAIL_TBL.[NO]) LEFT JOIN CARD_TBL ON AUC_SEQ.SEQNO = CARD_TBL.SEQNO;