fix album_tracks

[id3fs.git] / lib / ID3FS / DB.pm

diff --git a/lib/ID3FS/DB.pm b/lib/ID3FS/DB.pm
index f2151e4..5217484 100644 (file)
--- a/lib/ID3FS/DB.pm
+++ b/lib/ID3FS/DB.pm
@@ -267,7 +267,7 @@ sub album_tracks
 {
     my($self, $album_id)=@_;
     my $sql=("SELECT files.name FROM files\n\t" .
-            "INNER JOIN files_x_albums ON albums.id=files_x_albums.albums_id\n\t" .
+            "INNER JOIN files_x_albums ON files.id=files_x_albums.files_id\n\t" .
             "INNER JOIN albums ON albums.id=files_x_albums.albums_id\n\t" .
             "WHERE albums.id=?\n\t" .
             "GROUP BY files.name\n");