SQL - Display Question

[AndrewWiggins99]

Here is the table structure. How can I display the data into one column (Access) grouped on User_ID and Group columns (see Expected Result)

Group DT ACCESS USER_ID
TAG 01/01/2019 U JOHNS
TAG 01/01/2019 R JOHNS
FIR 01/02/2009 R SAMS

Result:
Group DT ACCESS USER_ID
TAG 01/01/2019 U, R JOHNS
FIR 01/02/2009 R SAMS

 

[djj55]

Look at PIVOT then let us know if you have questions.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!