So far I haven't been successful in my search on combining 4 tables. I have 4 tables: 

**content**

```
content_id | source_id | content_title   | content_date
--------------------------------------------------------
1          | 1         | The factory     | 189982398300
2          | 2         | Cold and cloudy | 189982398299
3          | 2         | Green tea       | 189982398298

```

**sources**

```
source_id | source_name
-------------------
1         | BBC
2         | Reuters

```

**settings**

```
setting_id | setting_name
-------------------------------
1          | bbc_iplayer_string
2          | reuters_video_id
3          | reuters_category

```

**content\_join\_settings**

```
content_id | setting_id | setting_data
------------------------------------------
1          | 1          | Js88sdhjsd0gDS09
2          | 2          | video_8AJK3ADJD8
2          | 3          | weather
3          | 2          | video_K7KD8N2ND9
3          | 3          | food and drinks

```

So as you might have already noticed every content record has it's own source linked to it, and comes with extra settings depending on the source. BBC posts have an `bbc_iplayer_string`, and posts from Reuters have a `reuters_video_id` and a `reuters_category`. Of course this is just an example.

I'd like to have the results combined, and with the `setting_name` as a column name. I'm not sure how to explain it so I'll show it:

```
content_id | source_name | content_title   | content_date | bbc_iplayer_string | reuters_video_id | reuters_category
--------------------------------------------------------------------------------------------------------
1          | BBC         | The factory     | 189982398300 | Js88sdhjsd0gDS09   | NULL             | NULL
2          | Reuters     | Cold and cloudy | 189982398299 | NULL               | video_8AJK3ADJD8 | weather
3          | Reuters     | Green tea       | 189982398298 | NULL               | video_K7KD8N2ND9 | food and drinks

```

I'm not very skilled in complex MySQL queries. I don't know where to start looking, let alone what to search for. I started with this query but I have no idea how to continue. I'm probably not even close.

```
SELECT 
  * 
FROM
  content,
  sources,
  settings,
  content_join_settings
WHERE
  content.content_id = content_join_settings.content_id AND
  settings.setting_id = content_join_settings.setting_id AND
  sources.source_id = content.source_id
GROUP BY
  content.content_id
ORDER BY
  content.content_date
  DESC

```