this needs an inner join.