新人问两个题目 求大神解答下 多谢了 救急

[sinat_32895865]

[zy18755122285]

1 DELETE FROM (TA LEFT JOIN TB ON TA.IDKEY=TB.IDKEY) T WHERE T.TYPE='类型一' 2select guest,sum(jc),count(*) from CUSTOMER group by guest

[bo871747022]

DELETE FROM TB WHERE DKey IN (SELECT DKey FROM TA WHERE TA.TYPE='类型一')
SELECT * FROM (SELECT guest,COUNT(je) c,SUM(je) s FROM TC GROUP BY  guest) where c>2 ORDER BY s ASC

[H_Gragon]

引用 2 楼 bo871747022 的回复:

DELETE FROM TB WHERE DKey IN (SELECT DKey FROM TA WHERE TA.TYPE='类型一')
SELECT * FROM (SELECT guest,COUNT(je) c,SUM(je) s FROM TC GROUP BY  guest) where c>2 ORDER BY s ASC