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;