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

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>

Retrieved from "https://htyp.org/mw/index.php?title=AudioFerret/v1/sql/qryCbx_Albums_byArtist&oldid=16648"