I have three tables:
eg: I want to select rows from the Map_table where Map_table.to_user_id = 1
and also provide the User_table.name where Map_table.from_user_id = User_table.id
and also provide the Content_table.title where Map_table.content_id = Content_table.id
Map_table.content_id might be null and therefore not map to the Content_table
If been through a load of answers here and still tearing my hair out to get the results I need.
Can any SQL gurus out there see a simple solution. The potential JOINs required are frying my brain.
Any help would be much appreciated. For the sake of my scalp, among other things ;)