Referencing Previous Row In Normal Select Statement

Hi,

I was wondering if it is possible to reference a value in a previous row as a field in a normal select statement, for example:

SELECT a.user_id, a.name, b.user_id, b.name
FROM Users a
LEFT OUTER JOIN Users b
WHERE (b.user_id = a.user_id - 1)

Unfortunantly my user_id values are not in sequence so I get null entries using that code. Instead of doing something as basic as -1 is there another way to reference the previous row?