apologies to start, i am soooo new to all this SQL stuff but:

could you not nest this inside another selection procces, eg!

Position: (SELECT Count(*) FROM (SELECT Count(*) FROM LeagueTable WHERE [LT].[Total Pts]< [Total Pts]) WHERE [LT].[GD]<[GD])

Or is that total rubbish?!?!?!?