Try this:
SELECT
max(case when a.Type_Id = 6 then a.Description end) As PROD,
max(case when a.Type_Id = 98 then a.Description end) As R,
max(case when a.Type_Id = 120 then a.Description end) As OWNER,
b.Client_Id as ClientID,
C.TextCol as NOTE
from
AMGR_User_Field_Defs A
inner join AMGR_User_Fields B on a.Type_Id = b.Type_Id and a.Code_Id = b.Code_Id
inner join AMGR_Client D on d.Client_Id = B.Client_Id
inner join AMGR_Notes C on b.Client_Id = c.Client_Id
WHERE
A.Type_Id = B.Type_Id
AND A.Code_Id = B.Code_Id
GROUP BY
b.Client_Id,
C.TextCol;