SELECT SS.SellID, S.SuperAvatarID
FROM SuperSell AS SS, SuperAvatar AS S
WHERE S.SuperAvatarID=SS.SuperAvatarID
GROUP S.SuperAvatarID
HAVING COUNT(S.SuperAvatarID) >= 2;
select SS.SellID, S.SuperAvatarID
from
(
select COUNT(SuperAvatarID) as ANS,SuperAvatarID
from SuperAvatar
group by [SuperAvatarID]
) as S,SuperSell AS SS
where S.ANS >=2 and S.SuperAvatarID=SS.SuperAvatarID
Load balance : Server 03
