same table multiple times in statement?

[Phillip Rhodes]

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.



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]