不支持连接表达式

select A.od,A.qian,A.dtime,A.hf,B.ztname from dd as A inner join zt as B on A.zid=B.ztid and A.uname= " + Session["UserName"].ToString() + " order by dtime DESC提示错误，数据库为access.

后来改为如下：select od,qian,dtime,hf,ztname from dd,zt where dd.zid=zt.ztid and  dd.uname= " + Session["UserName"].ToString() + " order by dd.dtime DESC 显示正常，