INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: MC11 search engine  (Read 671 times)

lamyseba

  • Regular Member
  • Member
  • *
  • Posts: 4
  • Change this by choosing profile
MC11 search engine
« 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
Logged

datdude

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 2222
Re: MC11 search engine
« Reply #1 on: April 26, 2005, 12:25:59 am »

I could be wrong but I thinks its just an indexed based database and not relational?
Logged
"You are not a beautiful or unique snowflake." -  Just a very big snowball
Pages: [1]   Go Up