SQL inner join 问题

来源：百度知道 编辑：UC知道 时间：2024/06/21 21:30:30
rs.open "select 1237_dingdan.dingdan,1237_dingdan.dingdanid,1237_dingdan.username,1237_dingdan.dingdandate,1237_dingdan.bookid,1237_dingdan.bookcount,1237_dingdan.dingdan,1237_dingdan.zhuangtai,1237_dingdan.shouhuoname,1237_dingdan.shouhuodizhi,1237_dingdan.zhifufangshi,1237_dingdan.songhuofangshi,1237_dingdan.shouyoubian,1237_dingdan.shouemail,1237_dingdan.zonger,1237_book.bookid 1237_book.bookname,1237_book.huiyuanjia,1237_book from 1237_book inner join 1237_dingdan on 1237_book.bookid =1237_dingdan.bookid where dingdan='"&trim(dingdan)&"' and username='"&request.Cookies("1237")("username")&"'",conn,1,1

提示如下：Microsoft JET Database Engine 错误 '80040e14'

语法错误 在查询表达式 '1237_dingdan.dingdan' 中。

/dingdan_show.asp，行6

请问这语句那错了....

rs.open "select b.dingdan,b.dingdanid,b.username,b.dingdandate,b.bookid,b.bookcount,b.dingdan,b.zhuangtai,b.shouhuoname,b.shouhuodizhi,b.zhifufangshi,b.songhuofangshi,b.shouyoubian,b.shouemail,b.zonger,a.bookid a.bookname,a.huiyuanjia from [1237_book] a inner join [1237_dingdan] b on a.bookid =b.bookid where b.dingdan='"&trim(dingdan)&"' and b.username='"&request.Cookies("1237")("username")&"'",conn,1,1