AudioFerret/v1/sql/qryArtists index
< AudioFerret | v1 | sql
Jump to navigation
Jump to search
SQL
<mysql>CREATE OR REPLACE VIEW qryArtists_index AS SELECT
id, name
FROM Artist UNION SELECT
id, sort
FROM Artist WHERE NULLIF(sort,) IS NOT NULL ORDER BY name;</mysql>