I wonder if anyone could help me.
I have 4 tables that need to be joined to retrieve the data i need.
So i want to do a simple select * from reviews. With this i require the theme name from
themes and the subtheme name from
A review can have more than one theme and subtheme. Also a review may only have a theme with no subthemes and then another theme with subthemes.
themes table look like this
reviewsubthemes look like this
reviews table looks like this:
I have tried but i am getting too confused.
So essentially the review table holds the reviews. The themes table is where the name of the themes are, and both reviewthemes and reviewsubthemes have a reviewID column to join with the
reviews table and a themeID to joni to the
Does anyone know how to do this and also can you explain how the query is made.