Query relazionate; con e senza inner join

[king size slim]

$query = "SELECT * FROM album AS a LEFT JOIN foto AS f ON a.id_foto_album = f.id_foto ORDER BY data_album DESC";