"select a.* from TBL_comc as a inner join TBL_comcP as b " & _
" on a.click_ID=b.click_ID inner join TBL_com as c " & _
" on b.CBC=c.CBC and c.CTypeID='" & Trim(CmbComType.Text) & _
"' order by a.stat_date desc"
" on a.click_ID=b.click_ID inner join TBL_com as c " & _
" on b.CBC=c.CBC and c.CTypeID='" & Trim(CmbComType.Text) & _
"' order by a.stat_date desc"
解决方案 »
- [菜鸟求助]根据两列字段值合并行
- 请问字段怎么作为函数的参数?
- 我用installshield12的Windows Installer打包VB程序后,为什么找不到脚本文件,只有两个空的文件夹Files和Functions?Windows Installer
- sql2000 数据库里的用户(角色上面那个!)最多是16380 个,再增加就报"错误15065:所有的用户id均已指派。"
- 为什么我建的一个触发器怎么删除,修改不了?
- 怎样同时向两个表里插入数据
- 求助邹建问题继续:
- 请SQL高手帮忙看一下这个问题?
- 急求SQL语句
- 很急的問題﹐大家看看
- 一个新闻表,一个类别表,新闻表中有类别字段,但是一个新闻可以不属于任何类别,如何查询?
- 郁闷了好几天了,请各位大虾帮帮忙!!!
"select a.* from TBL_comc a inner join TBL_comcP b " & _
" on a.click_ID=b.click_ID inner join TBL_com c " & _
" on b.CBC=c.CBC where c.CTypeID='" & Trim(CmbComType.Text) & _
"' order by a.stat_date desc"
" on a.click_ID=b.click_ID inner join TBL_com c " & _
" on b.CBC=c.CBC where c.CTypeID='" & Trim(CmbComType.Text) & _
"' order by a.stat_date desc"
嘎嘎,哪里跑出来那么多as!
" on a.click_ID=b.click_ID inner join TBL_com c " & _
" on b.CBC=c.CBC where c.CTypeID=" & Trim(CmbComType.Text) & _
" order by a.stat_date desc"
既然邹建大侠说在SQL中没有问题那么在ACCESS中却出现语法错误,我不明白呀
"select a.* from TBL_comc as a inner join (TBL_comcP as b " & _
" inner join TBL_com as c on b.CBC=c.CBC) " & _
" on a.clic_ID=b.clic_ID where c.CTypeID='" & Trim(CmbComType.Text) & _
"' order by a.stat_date desc"
感谢各位