I need a way to display all of the challenge names from the challenges table along with the member names within the completed_challenges_junction. Where there is no match I would like it to display NULL.
I think I'm pretty close to having my SQL code working, here is what I have now.
SELECT challenges.Challenge_Name, challenges.Challenge_Description, completed_challenges_junction.Member_Names FROM challenges LEFT JOIN completed_challenges_junction ON challenges.Challenge_Name=completed_challenges_junction.Challenge_Name WHERE Member_Names='membername' OR Member_Names=null
Thanks for any replies.