same table multiple times in statement?

[Phillip Rhodes <sp...@rhoderunner.com>]

I need to refer to the same table in multiple joins (i think it's called 
self-referential).
Can Torque support this?

I have a user search, and I am making certain that the person performing 
the search is a member of same group as any of the returned results.

For example:
select * from users as users1,users as users2,group_users
where
users1.user_id = group_users.user_id
and
users2.user_id = group_users.user_id

Thanks.