MySQL Forums
Forum List  »  General

Help with derived table from many to many relationship
Posted by: Christian Nuvoli
Date: March 19, 2016 11:42AM

Hello, I don't know if this is the right place to ask anyway I try.
I'm working on a project where I have a schema similar to the one in the picture.
I can't find a way to get the data aggregated as this:
the authenticated user submits a search for "fender stratocaster", the result should be all the fender stratocasters that are currently in the collections of other users that share the same hand and gender as the auth user. Let's say there is only one model named stratocaster, so the program will show that model along with the number of each finish.. example solid X, transparent Y, whatever Z
Let's say there are two or three, I want a derived table that looks like this:


https://cdn-standard.discourse.org/uploads/sqlteam/original/1X/8f9cd0d2a64524f7537e7effee2e56248a53f275.jpg

Options: ReplyQuote


Subject
Written By
Posted
Help with derived table from many to many relationship
March 19, 2016 11:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.