<[EMAIL PROTECTED]> writes: > I'd love to be able to do that, but I cannot just ORDER BY uu.add_date, > because I do not have uu.add_date in the SELECT part of the statement.
Sure you can. Back around SQL89 there was a restriction that ORDER BY values had to appear in the SELECT list as well, but no modern database has such a restriction anymore ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend