SQL Problem

Hi,

I'm using an Access 2002 DB accessed via ASP.

This is my SQL query:
SELECT *, GoalsFor - GoalsAg AS GoalsDif FROM tblTeams ORDER BY TotalPoints DESC, GoalsDif DESC

I'm using an alias(GoalsDif) in the SQL query above to create a sum of two columns in my db table. The problem I'm having is that it wont let me sort the table by the alias GoalDif. It works fine with just TotalPoints DESC but not with GoalsDif DESC.

Can anyone let me know where I'm going wrong please??

Many Thanks

Justin

Hi Michael,

Thanks for your reply. I've sorted the problem now. A friend emailed me this the morning:

SELECT tblTeams.*, ([GoalsFor]-[GoalsAg]) AS GoalDif FROM tblTeams ORDER BY tblTeams.TotalPoints DESC , ([GoalsFor]-[GoalsAg]) DESC

It does the trick.

Thanks

Justin