AudioFerret/v1/sql/qryCbx Albums byArtist

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< AudioFerret‎ | v1‎ | sql
Jump to: navigation, search

About

  • Uses: Album
  • History:
    • 2012-01-09 Fixed reference to Album (was "Albums")

SQL

<mysql>CREATE OR REPLACE VIEW qryCbx_Albums_byArtist AS

 SELECT
   a.id,
   a.name,
   a.sort,
   a.idartist AS ID_Artist
 FROM Album AS a

ORDER BY a.idartist, CONCAT(sort,name);</mysql>