Msg#: 4480797 posted 10:00 pm on Jan 25, 2013 (gmt 0)
For MySQL Try:
SELECT (SELECT a.team FROM standing a WHERE a.points < c.points ORDER BY a.Team = 15, a.points DESC LIMIT 1), (SELECT b.Team FROM standing b WHERE b.points > c.points ORDER BY a.Team = 15, b.points LIMIT 1) FROM standing c WHERE Team = 15
Basically the above does three queries at once - one to get Team 15's points, one to get the teams (that aren't #15) with less points, and one to get the teams (that aren't #15) with more points.
There are other ways to do it in SQL, but this way seems the easiest to understand.