Concatenate multiple records into one line

Hi,

Please can someone help, this is the query below. I need to combine the results from multiple rows into one.

select 

USR, 

USRNAME, AUTPROFILES.AUTPROFNAME

from USERAUTPROFILES

inner join USERS using (USRIK)

inner join AUTPROFILES using (AUTPROFIK)

where INACTIVE='0'

and USR not in 'SERVER'

order by USR

Current Results:

AAIND XYZ MIPD Risk and Compliance

AAIND XYZ Use servers for calculations

Required results:

AAIND XYZ MIPD Risk and Compliance, Use servers for calculations

Thanks and regards

James