TSQL Msg 1013 “Utiliser un nom d'alias pour les distinguer.”

J'ai regardé creux de nombreuses suggestions et ne peuvent pas comprendre comment résoudre ce un pour les deux dernières heures.

SET DATEFORMAT DMY
DECLARE @Source DATETIME = '01/01/2001'
DECLARE @Destenaition DATETIME = '01/01/2020'
SELECT ST.[Group],
ST.Shop,
SUM(ST.Purchased) AS Total,
CHG.Charged
FROM   (SELECT Personals.Groups.[Name]      AS 'Group',
Cards.vPurchases.PersonalID,
Personals.Registry.[Name],
SUM(Cards.vPurchases.Ammont) AS Purchased,
Cards.vPurchases.ShopName    AS Shop
FROM   Cards.vPurchases
INNER JOIN Personals.Registry
ON Personals.Registry.Id = Cards.vPurchases.PersonalID
INNER JOIN Personals.Groups
ON Personals.Registry.[Group] = Personals.Groups.Id
INNER JOIN Personals.Groups
ON Personals.Groups.Id = CHG.GroupID
WHERE  Cards.vPurchases.[TimeStamp] >= @Source
AND Cards.vPurchases.[TimeStamp] <= @Destenaition
GROUP  BY Cards.vPurchases.PersonalID,
Personals.Registry.[Name],
Personals.Groups.[Name],
Cards.vPurchases.ShopName) ST,
(SELECT PG.Id                      AS GroupID,
SUM(Cards.vCharges.Amount) AS Charged
FROM   Cards.vCharges
INNER JOIN Personals.Registry
ON Personals.Registry.Id = Cards.vCharges.PersonalID
INNER JOIN Personals.Groups AS PG
ON Personals.Registry.[Group] = PG.Id
WHERE  Cards.vCharges.[TimeStamp] >= @Source
AND Cards.vCharges.[TimeStamp] <= @Destenaition
GROUP  BY Personals.Groups.[Name]) AS CHG
GROUP  BY ST.Shop,
ST.[Group]  

Et puis j'ai cette erreur:

Msg 1013, Niveau 16, État 1, Ligne 6 objets "Personnels.Les groupes" et
"Rencontres.Les groupes" dans la clause from ont le même exposé des noms. Utilisation
des noms d'alias pour les distinguer.

Grâce.

OriginalL'auteur Slime recipe | 2011-10-16