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>