select c.companyPKeyID, u.company
from tbl_LIB_Accounts a
inner join tbl_LIB_Companies c
on c.companyid = a.companyid
and c.companyPType = 'msc'
inner join tbl_MSC_FSLibraryUsers u
on u.userid = c.companyPKeyID
where a.FSPro_UserID =
and a.companyid in ( 132, 285, 2679, 2113, 2114, 2913, 2720 )
and a.moduleid = 42
order by u.company