P_VAAG

SELECT     a.puid, a.pseq, a.pval_0, a.PIPNOTE_TEXTS_0_1_0, b.pvalu_0, c.pname, c.pdesc
FROM         dbo.PNOTE_TEXTS_0 AS a LEFT OUTER JOIN
                      dbo.PNOTE_TYPES_0 AS b ON a.puid = b.puid AND a.pseq = b.pseq LEFT OUTER JOIN
                      dbo.PNOTETYPE AS c ON b.pvalu_0 = c.puid