Help required -Writing join queries - mysql
Posted on 2013-05-20
I have 3 tables
1)collections(a music collection - id of which would be passed) - id is the relevant column name
2)collection_content_mappings(contains the columns pair - collections id(collections table above) - content id(content_details below)) - collections_id, content_id are the relevant column names in this table
3)content_details - content_id is the relevant column name in this table
4)content_additionals - content_id(of content_details above) is the relevant column name
Need to fetch all the details from content_details and content_additionals; the only input would be corresponding to the id field for 'collections' table.
I would appreciate, if someone can help me write joint queries for the same.