SELECT Affiliate.NoMember,SUM(Affiliate.Amount) AS Amount,MAX(Member.Numero) AS Numero,MAX(Member.FirstName) AS FirstName,; MAX(Member.LastName) AS LastName; FROM Affiliate; INNER JOIN Member ON Affiliate.NoMember=Member.Numero; WHERE Affiliate.Period<=ldDate AND Affiliate.NoCheque=0; GROUP BY NoMemberBut, if I add an HAVING clause, I have an error on the HAVING clause complaining that it is invalid:
SELECT Affiliate.NoMember,SUM(Affiliate.Amount) AS Amount,MAX(Member.Numero) AS Numero,MAX(Member.FirstName) AS FirstName,; MAX(Member.LastName) AS LastName; FROM Affiliate; INNER JOIN Member ON Affiliate.NoMember=Member.Numero; WHERE Affiliate.Period<=ldDate AND Affiliate.NoCheque=0; GROUP BY NoMember; HAVING Amount>100This is a SQL I have been using for a while. I just can't find what I changed today in it making it to no longer work.