fixed incorrect join (now left outer