As far as I know, you can't use an alias in a calculation outside of a
HAVING clause. You could work around this by adding the calculation to your
SELECT clause:
SELECT kills.PlayerID, player.DeathsPerMinute,
SUM(kills.Kills) AS Total,
SUM(kills.Kills) * (1-player.DeathsPerMi
I\'m trying to order by an alias in a multi table SELECT statement(Note I\'ve cut the
statement down a bit to make it more readable):
SELECT kills.PlayerID, player.DeathsPerMinute, SUM(kills.Kills) AS Total FROM
playerweaponkills AS kills, ETPlayerSummary AS player WHERE
kills.PlayerID=player.
