Charramma@TENNIS 10:24 mysql>SELECT PLAYERNO,TOWN,SEX FROM PLAYERS WHERE SEX = (SELECT SEX FROM PLAYERS WHERE PLAYERNO = 44) AND TOWN = (SELECT TOWN FROM PLAYERS WHERE PLAYERNO = 7);
±---------±----------±----+
| PLAYERNO | TOWN | SEX |
±---------±----------±----+
| 2 | Stratford | M |
| 6 | Stratford | M |
| 7 | Stratford | M |
| 39 | Stratford | M |
| 57 | Stratford | M |
| 83 | Stratford | M |
| 100 | Stratford | M |
±---------±----------±----+
7 rows in set (0.00 sec)
Charramma@TENNIS 10:31 mysql>