By the way, i came with this, but this only count/sums whatever for the column value, i need to get the original value from the possible relation between the tables

DECLARE @Cols NVARCHAR(MAX)

DECLARE @Sql AS NVARCHAR(MAX)

SET @Cols = STUFF((SELECT ',' + QUOTENAME(descr) FROM #Job FOR XML PATH(''),TYPE).value('.','NVARCHAR(MAX)'),1,1,'')

SET @Sql = 'SELECT * FROM

(SELECT P.id , P.name , J.descr

FROM #Person P LEFT OUTER JOIN #PersonJobs PJ ON P.id = PJ.idP

LEFT OUTER JOIN #Job J ON J.id = PJ.idJ) QR

PIVOT(

SUM(id)

FOR descr IN (' + @Cols +')

) PV'

EXEC sys.sp_executesql @Sql

Thanks