Using joins to add teams id into player