using a view for a join