Help with derived table from many to many relationship
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
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.