AudioFerret/v1/sql/qryArtists index
< 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.
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>