In this scenario, I was attempting to Left Join a table to another table and Inner Joining them to a third table. I ended up getting no results from the query.
A bit of research found this link:
http://www.sitepoint.com/forums/showthread.php?769412-Combining-Left-and-Inner-Joins
In short, you have to perform the Inner Joins first before you Left Join.
My solution was to Left Join the entire way. My reason for the Inner Join in the first place, and the reason why I’m unsure of this method was that it seemed like a good way to kill performance. However, I’m not at the stage where I need to kill time performance tuning the system so I’ll have to ignore it for now.
I’m probably wrong anyway, but it wouldn’t hurt to check when I finally get the time.