insert into tb_indiana_member_bak20160603
(
select * from `tb_indiana_member` t where t.`indiana_member` in (3768,4558,6126,6574,6596,6597) and t.`create_date` like '2016-06-03%'
and t.`payment_sn` not in (select p.`sn` from xx_payment p where p.`status` = 1 and p.`member` in (3768,4558,6126,6574,6596,6597) and p.`create_date` like '2016-06-03%')
)
(
select * from `tb_indiana_member` t where t.`indiana_member` in (3768,4558,6126,6574,6596,6597) and t.`create_date` like '2016-06-03%'
and t.`payment_sn` not in (select p.`sn` from xx_payment p where p.`status` = 1 and p.`member` in (3768,4558,6126,6574,6596,6597) and p.`create_date` like '2016-06-03%')
)
扫一扫
198
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
