delete from TB a where a.IDKey in (select b.IDKey from TA b where b.type = '类型一');
select Guest, count(1) as xfcs, sum(je) as ljxfje from TC where Guest in (select Guest From TC group by Guest having count(1) > 2) order by sum(je) desc;
delete from TB a where a.IDKey in (select b.IDKey from TA b where b.type = '类型一');
select Guest, count(1) as xfcs, sum(je) as ljxfje from TC where Guest in (select Guest From TC group by Guest having count(1) > 2) group by Guest order by sum(je) desc;
第一个问题这种: delete from TB a where a.IDKey in (select b.IDKey from TA b where b.type = '类型一');
where a.IDKey in (select b.IDKey from TA b where b.type = '类型一');
select Guest, count(1) as xfcs, sum(je) as ljxfje
from TC
where Guest in (select Guest From TC group by Guest having count(1) > 2)
order by sum(je) desc;
where a.IDKey in (select b.IDKey from TA b where b.type = '类型一');
select Guest, count(1) as xfcs, sum(je) as ljxfje
from TC
where Guest in (select Guest From TC group by Guest having count(1) > 2)
group by Guest
order by sum(je) desc;
delete from TB a
where a.IDKey in (select b.IDKey from TA b where b.type = '类型一');