黄山昌仁医院妇科:关于 inner join和WHERE

if atcions=today then
set rs=server.CreateObject("adodb.recordset")
sql="select shop_books.pingpai,shop_books.anclassid,shop_books.bookid,shop_books.bookname,shop_books.shichangjia,shop_books.huiyuanjia,shop_action.actiondate,shop_action.shousex,shop_action.userzhenshiname,shop_action.USERname,shop_action.shouhuoname,shop_action.dingdan,shop_action.youbian,shop_action.liuyan,shop_action.zhifufangshi,shop_action.songhuofangshi,shop_action.zhuangtai,shop_action.zonger,shop_action.useremail,shop_action.usertel,shop_action.shouhuodizhi,shop_action.bookcount,shop_action.danjia,shop_action.fapiao,shop_action.feiyong from shop_books inner join shop_action on shop_books.bookid=shop_action.bookid where shop_action.username='lys1108'"
rs.open sql,conn,3,3
end if

if atcions=all then
set rs=server.CreateObject("adodb.recordset")
sql="select shop_books.pingpai,shop_books.anclassid,shop_books.bookid,shop_books.bookname,shop_books.shichangjia,shop_books.huiyuanjia,shop_action.actiondate,shop_action.shousex,shop_action.userzhenshiname,shop_action.USERname,shop_action.shouhuoname,shop_action.dingdan,shop_action.youbian,shop_action.liuyan,shop_action.zhifufangshi,shop_action.songhuofangshi,shop_action.zhuangtai,shop_action.zonger,shop_action.useremail,shop_action.usertel,shop_action.shouhuodizhi,shop_action.bookcount,shop_action.danjia,shop_action.fapiao,shop_action.feiyong from shop_books inner join shop_action on shop_books.bookid=shop_action.bookid"
rs.open sql,conn,1,3
end if

以上两种条件查询结果，都一样，不能筛选出shop_action.username='lys1108'的数据
maddemon - 助理 二级
感谢你的答 ，但是我试过，筛选结果，还是不能按条件筛选，而是全部列出。