INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: lamyseba on April 25, 2005, 05:10:16 pm

Title: MC11 search engine
Post by: lamyseba on April 25, 2005, 05:10:16 pm

Hi. Is it possible to do sql request with mc11, and does it use more than 1 database table?
The goal is: I want to have a view sheme with all the songs from artists from wich i own at least ten songs, and i cannot do that with MC10.

select songs.SongName from songs where Artist in
(select songs.Artist group by songs.Artist having count*>10)
Here it is.
So is it worse for me buying MC11?
Thanks in advance for your answers

Title: Re: MC11 search engine
Post by: datdude on April 26, 2005, 12:25:59 am

I could be wrong but I thinks its just an indexed based database and not relational?