- Foxtable(狐表) (http://www.foxtable.com/bbs/index.asp)
-- 专家坐堂 (http://www.foxtable.com/bbs/list.asp?boardid=2)
---- 下面语句怎么写不报错？ (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=106812)
-- 发布时间：2017/9/15 22:46:00
-- 下面语句怎么写不报错？
cmd.CommandText = "s elect case when a.shopid=0 then \'公司总部\' Else \'腾远宝贝王淘气堡区\' End, a.wsname As 服务名称,a.trancount As 次数,b.membercardsn As 会员卡号,b.membername As 会员姓名,b.yinshoujiner,b.daijinquan,b.weixinjiner &_
from {sealacc} a inner join {sealhdhacc} b on (a.sealhdhaccid=b.sealhdhaccid And a.TranCount>1) inner join {members} c on (b.membercardsn=c.membercardsn And c.memberdeptid<>0)"
-- 发布时间：2017/9/15 22:57:00
--
......from {sealacc} a inner join {sealhdhacc} b on a.sealhdhaccid=b.sealhdhaccid
inner join {members} c on (b.membercardsn=c.membercardsn
where a.TranCount>1 and c.memberdeptid<>0
-- 发布时间：2017/9/15 23:06:00
--
确定后还是报错啊？
此主题相关图片如下：1.png
-- 发布时间：2017/9/15 23:20:00
--
"s elect case when a.shopid=0 then \'公司总部\' Else \'腾远宝贝王淘气堡区\' End, a.wsname As 服务名称,a.trancount As 次数,b.membercardsn As 会员卡号,b.membername As 会员姓名,b.yinshoujiner,b.daijinquan,b.weixinjiner" &_
"from {sealacc} ......