stereoptic wrote:
> I need to brush up on my SQL.
> What would be an example of listing the albumname, the sort album name ,
> album artist and sort album artist from the albums (?) table?
> I would be using the database query function in LMS, I don't have any
> other SQL loaded on this PC right now.
>
> Thanks!
I think something kinda like this should get you started:
Code:
--------------------
SELECT TRIM(CAST(al.title AS CHAR(150))) AS "Album Name",
al.titlesort AS "Sort Album Name",
TRIM(CAST(co.name AS CHAR(150))) AS "Album Artist",
co.namesort AS "Sort Album Artist"
FROM albums al,
contributor_album ca,
contributors co
WHERE ca.album = al.id
AND co.id = ca.contributor
ORDER BY 1, 3
--------------------
------------------------------------------------------------------------
Dogberry2's Profile: http://forums.slimdevices.com/member.php?userid=18883
View this thread: http://forums.slimdevices.com/showthread.php?t=101600
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss
