Quote Originally Posted by bokehman View Post
Thanks for all the help. Just a couple of questions... is the subquery like having a separate table as far as the outer query is concerned?
exactly!

Quote Originally Posted by bokehman View Post
And why does the result com out in reverse order (newest first)?
because i forgot the DESC in the ORDER BY