I dont have the SQL schema to hand - but how are the genres stored for each track ?
If I was writing such a query where I needed to check multiple items I would join the table to itself on its primary key So something like select item from track1 join track2 on track1.key = track2.key and track2.genre in 'Holiday' where track1.genre in 'Jazz' or something along those lines ------------------------------------------------------------------------ bradcook's Profile: http://forums.slimdevices.com/member.php?userid=1033 View this thread: http://forums.slimdevices.com/showthread.php?t=109818 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
