#1248 - Every derived table must have its own alias

[sseeley]

Can anyone help why I am getting this error?

 

SELECT SUM(NUMBERTEAMS1) FROM

(

SELECT tblteamentry.confirm1 AS NUMBERTEAMS1 FROM middlesexwingsports.tblteamentry

WHERE tblteamentry.fkAgeGroupId = '11'

AND tblteamentry.confirm1 = '1'

)

 

Thanks in advance for any help.

[Mchl]

SELECT SUM(NUMBERTEAMS1) FROM
(
SELECT tblteamentry.confirm1 AS NUMBERTEAMS1 FROM middlesexwingsports.tblteamentry
         WHERE tblteamentry.fkAgeGroupId = '11'
         AND tblteamentry.confirm1 = '1'
) AS aliasForThisSubquery