use inner join for teams