我有5个表 BHSH CKKC MDKC SYXL BYXL
我需要根据BHSH表的内容返回 其他表关联的值,VB6运行提示语法错误
strSQL = "select * from BHSH t1 left join CKKC t2 on t2.ck_CKMC=t1.bh_CK and t2.ck_SPTM=t1.bh_SPTM left join MDKC t3 on t3.md_CKMC=t2.ck_CKMC and t3.md_SPTM=t2.ck_SPTM left join SYXL t4 on t4.syxl_CK=t3.md_CKMC and t4.syxl_SPTM=t3.md_SPTM left join BYXL t5 on t5.byxl_CK=t4.syxl_CK and t5.byxl_SPTM= t4.syxl_SPTM"
Set xlsadoRst = mdbadocnn.Execute(strSQL)
错误提示是: 语法错误(操作符丢失),在查询表达式''中
我仔细检查了各个表相关列的名称.
真心求助,望各位看官指点,谢谢!