If I could just do like a left join my life would be so much easier.