Let's Say i have a Database that stores results from basketball games.
i have a Table Called Matches, and a another Called Quarters , a Match can
have many Quarters.
(Please don't give me adivces about design because i'm giving this table as
example my DB is too big to explain an show )
MATCHES TABLE QUARTERS TABLE
how can i do a query or stored procedure that returns the list of matches
and a colum in each record with the concatenated Names of the HighScorers
with No Repeatings.
MATCHID TEAM1 TEAM2 HIGHSCORERS
1 1 2
Jones,Jordan (Jordan can be High Scorer on 3 Periods but i only want the
2 1 3
3 1 27
4 27 4 Dr J,