AudioFerret/v1/sql/qryCbx Artists: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
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
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>
