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
Revision as of 02:42, 10 January 2012 by Woozle (talk | contribs) (extracted from main page; fixed reference to "Album" (was "Albums"))
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to 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>

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