mysql> select Brano.Titolo from Brano, Tracklist where Tracklist.IDAlbum = '3'; +--------------------------+ | Titolo | +--------------------------+ | Let It Rock | | Let It Rock | | You Give Love A Bad Name | | You Give Love A Bad Name | +--------------------------+ 4 rows in set (0.00 sec) mysql> select * from Tracklist; +---------+---------+ | IDAlbum | IDBrano | +---------+---------+ | 3 | 1 | | 3 | 2 | +---------+---------+ 2 rows in set (0.00 sec) mysql> select * from Brano; +---------+--------------------------+----------+------+------------+ | IDBrano | Titolo | Durata | Anno | NomeGenere | +---------+--------------------------+----------+------+------------+ | 1 | Let It Rock | 05:24:00 | 1986 | Rock | | 2 | You Give Love A Bad Name | 03:44:00 | 1986 | Rock | +---------+--------------------------+----------+------+------------+ 2 rows in set (0.00 sec) mysql>