|
| |
|
|
| |
для: d-111
(01.08.2006 в 15:51)
| | |
SELECT members.login as login FROM members,teams as t1, teams as t2
WHERE t1.member = '9' AND t2.project = t1.project AND members.id = t2.member
|
| |
| |
|
|
| |
|
|
| | "SELECT project FROM teams WHERE member = '9'";
"SELECT member FROM teams WHERE project = '$project'";
"SELCET login FROM members WHERE id = '$member'";
Такой вариант не подходит Мускул старой версии
SELECT login FROM members WHERE id IN
(SELECT DISTINCT member FROM teams WHERE project IN
(SELECT project FROM teams WHERE member = 9) AND member != 9) | |
| |
|
|
|
