• I think I got it using a full outer join.