db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Phillip Rhodes <spamsu...@rhoderunner.com>
Subject same table multiple times in statement?
Date Tue, 25 Mar 2003 03:19:28 GMT
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.



Mime
View raw message