Hi there
the case:
- one table with users (tblUser)
- one table with groups (tblgroups)
- one table with user-group links (tbluserlink) - describes which groups one
user belongs to, in a many-to-many relationship
the question:
I want to make a select where I get all the users, that are in the same
groups as myself. How do I do this with multiple joins, when I can't do a
select in(select)?
Thanks in advance!
Regards,
/Henrik Mohr
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php