AudioFerret/v1/sql/qryCbx Artists

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 Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

About

  • Uses: Artist
  • History:
    • 2012-01-09 Fixed reference to Artist (was "Artists")

SQL

<mysql>CREATE OR REPLACE VIEW qryCbx_Artists AS 

 SELECT
   a1.ID,
   a1.Name AS Name
 FROM Artist AS a1

UNION 

 SELECT
   a2.ID,
   a2.Sort AS Name
 FROM Artist AS a2
 WHERE (a2.Sort <> ) AND (a2.Sort <> a2.Name)

ORDER BY Name;</mysql>

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