Difference between revisions of "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
(extracted from main page; fixed reference to "Artist" (was "Artists"))
 
(note about fixing table name)
 
Line 1: Line 1:
 
==About==
 
==About==
 
* '''Uses''': {{l/same|Artist}}
 
* '''Uses''': {{l/same|Artist}}
 +
* '''History''':
 +
** '''2012-01-09''' Fixed reference to {{l/same|Artist}} (was "Artists")
 
==SQL==
 
==SQL==
 
<mysql>CREATE OR REPLACE VIEW qryCbx_Artists AS
 
<mysql>CREATE OR REPLACE VIEW qryCbx_Artists AS

Latest revision as of 02:43, 10 January 2012

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"