AudioFerret/v1/sql/qryCbx Artists

About

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

SQL
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;