【问】食通天6能不能单独清除一个类别的会员数据？
【适用版本】食通天5	【模块】会员管理	【点击数】31
【知识编号】C2015011300046
【问题描述】食通天6能不能单独清除一个类别的会员数据？

【答】 下面给出语句示例：如清除会员类型中，类型编号为1下的所有会员以及这些会员的充值消费余额。请先备份数据库以免误操作造成损失。
use issrestv6
go
delete from t_m_member_log where vch_memberno in(select vch_memberno from t_m_member where ch_typeno = ‘1’)
delete from t_m_member_other where vch_memberno in(select vch_memberno from t_m_member where ch_typeno = ‘1’)
delete from t_m_deposit where vch_memberno in(select vch_memberno from t_m_member where ch_typeno = ‘1’)
delete from t_m_pay where vch_memberno in(select vch_memberno from t_m_member where ch_typeno = ‘1’)
delete from t_m_point where vch_memberno in(select vch_memberno from t_m_member where ch_typeno = ‘1’)
delete from t_m_curamount where vch_memberno in(select vch_memberno from t_m_member where ch_typeno = ‘1’)
delete from t_m_member where ch_typeno = ‘1’
delete from t_m_member_type where ch_typeno = ‘1’