RDS Multiple Licensing Servers

Question

Thanks for the feedback on my lousy question. First time around here.

I'm working with SQlite and C# in Visual Studio.

This is a sample of the data in my tables:

TABLE: VIDEOS
-------------
ID  VideoName             VideoStarID       VideoCostarID
--------------------------------------------------------------
1   Casablanca                23                 43
2   Maltese Falcon            23                156
3   Matrix                   234                312
4   Matrix Reloaded          234                312
5   Matrix Revolutions       234                312
6   Pompeii                  312

TABLE: STARS
-------------
ID  StarName        
------------------------------
23  Humphrey Bogart 
43  Ingrid Bergman
156 Mary Astor
234 Keanu Reeves
312 Carrie-Anne Moss

TABLE: TAGS
-------------
ID  TagName     
------------------------------
1   Action
2   Classic
3   Drama
4   Horror
5   Thriller
6   Sci-Fi
7   Romance
8   Western
9   War
10  Film Noir
11  Comedy
12  History
13  Dystopia

TABLE: VIDEO_TAGS
-------------
VideoID     TagID   
------------------------------
1            2
1            5
1            7
1            9
2            1
2            2
2            5
3            1
3            5
3            6
3            13
4            1
4            5
4            6
4            13
5            1
5            5
5            6
5            13
6            12
6            3

I would like to select all movies starring Carrie-Anne Moss and Keanu Reeves with tags "Action", "Sci-Fi" and "Thriller". Actually, my query is gonna be more complex than that in the future, since I will have to be able to include parameters for year, studio, oscar nominations, oscars won, rating, etc.; but for now, the problem I am having is that I cannot get an output like this:

-----------------------------------------------------------------------------------------------------
|VideoID |      VideoName    |   StarName   |    CostarName    |         Tags                       |
-----------------------------------------------------------------------------------------------------
|   3    |Matrix             | Keanu Reeves | Carrie-Anne Moss | Action, Sci-Fi, Thriller, Dystopia |
|   4    |Matrix Reloaded    | Keanu Reeves | Carrie-Anne Moss | Action, Sci-Fi, Thriller, Dystopia |
|   4    |Matrix Revolutions | Keanu Reeves | Carrie-Anne Moss | Action, Sci-Fi, Thriller, Dystopia |
-----------------------------------------------------------------------------------------------------

I tried this (obviously) faulty query:

SELECT VIDEOS.ID, VIDEOS.VideoName, VIDEOS.StarID, VIDEOS.CostarID, STARS.StarName, GROUP_CONCAT(TAGS.Name) AS Tags
FROM VIDEOS
INNER JOIN STARS ON VIDEOS.StarID = STARS.ID
INNER JOIN VIDEO_TAGS ON VIDEOS.ID = VIDEO_TAGS.VideoID
INNER JOIN TAGS ON TAGS.ID = VIDEO_TAGS.TagID
WHERE 
VIDEOS.StarID = 234 AND 
VIDEOS.CostarID = 312 AND
VIDEO_TAGS = 1 AND
VIDEO_TAGS = 5 AND
VIDEO_TAGS = 6

The result is just one row. It does not get all the movies. I also don't get the tags as I want.

Hope this information helps. Any help would be really appreciated.

Thanks in advance.

Solution

When you buy RDS CAL's you don't buy them for a particular RDS Licensing server, so you can split the CAL's across as many RDS Licensing servers as you need or want to.

Comments

[ADyson]

Without knowing the DBMS, or having any sample data, or expected results, or seeing your existing (faulty) query, or having proper information about the schema, it might be possible to get to the right answer, but you are making it really difficult for us. Take time to write your question with full details and clear explanations, and make it really easy for people to help you. You're much more likely to get a high number of good, useful answers if you do that, rather than one or two people with too much time on their hands having a bit of a guess.

[ADyson]

See stackoverflow.com/help/how-to-ask and also meta.stackoverflow.com/questions/333952/… for some guidance around asking a better more answerable question. Then consider editing and improving your question. Imagine you were trying to answer a question about a database you'd never seen before, and think of what kind of information you'd find useful. Then go and add that to your own question. We cannot read your screen, your disk...or your mind. Thanks.

[Jose De Cordova]

Thanks for your comments. Please, see my edited question. Thanks!

[PnP]

So if I have 120 CALs in total as one purchase, as a Select Agreement and not an OPEN agreement, I can use that set of CALs split among my servers. So activate the CALs on multiple Licensing Servers as long as the total no. of CALs I activate doesn't go above my purchased number?

[joeqwerty]

I've never seen any information that would lead me to believe that this isn't possible/legitimate. When you purchase the CAL's there's no server specific identification or configuration. You purchase the total number of CAL's you need and "install" them on as many RDS License servers as you need. We have 2 and have the CAL's split between the 2.

[Jose De Cordova]

Thanks! This solution works great! Would you please tell me how to add another condition? I would need to add something like "Rating >= 5". The "Rating" column belongs to the same Videos table. How can I add this condition to this (already way above my head) query? Thanks again!

[Jose De Cordova]

Thanks! Great solution. I really appreciate it.