Related Post: Left Join Same Table Twice With Different Conditions Left Join Same Table With Different Conditions Left Join When Right Table Has Multiple Matches