I have three tables set up as follows:

CallReports Table

 CallReport_Id        etc...
1
2
3



CallReport_Users Table

CallReport_Id         UserId
1                             A
2                             A
2                             B
2                             C
3                             C


CallReport_Companys Table

CallReport_id         Company_id
1                                G
1                                H
2                                M
3                                K

I would like a single cursor/table that shows a single line for each callreport_id and either the userid, if a single entry, or the word 'Multiple,' if there are multiple userids for a callreport_id. The same for the company_id. For example:

CallReport_id                 UserId                          Company_id
1                                   A                                 'Multiple'
2                                  'Multiple'                        M
3                                  C                                  'Multiple'

Can someone provide some guidance on how to accomplish this?

Thanks in advance,
Russell