There is probably a simple answer to this, but I'm not having much luck doing a left join with the following code.
http://www.sspaste.com/paste/show/508389db7d609
What I am trying to achieve with the leftjoin is to only select projects who have a projectimage that's Home value is 1 (true).
Can anyone point me in the right direction?