join statement to show party name