I have a table that has Name, Team, Week
I want to be able to select and have the result show me the Name and the Teams picked for that name. So data will look like this
I was the result to look like this
Tim,New England, Buffalo.
Is this possible with a mysql select statement? Thanks,