Trouble joining users and campaigns tables
I have a users table and a campaigns table. I'm trying to show all users where guide = 12481, regardless if they have a response in the campaign table or not. But I'm getting confused with the multiple joins. Can you help?
date_format(u.registerDate, '%m-%d-%Y') as registered
,date_format(u.last, '%m-%d-%Y') as last
,date_format(c.answerDate, '%m-%d-%Y') as latestAnswer
WHERE campaign = 'Enrollment'
u.uID = r.uID
r.uID = c.uID
r.mostRecent = c.answerDate
u.guide = 12481