lista wypłat

select * from cdn.ListyPlac


select PRE_Nazwisko, PRE_Imie1, Sum(WPE_Wartosc) as brutto, wpl_wartosc as netto from cdn.Wyplaty
JOIN CDN.WypElementy ON WPE_WPLID = WPL_WPLID
JOIN CDN.PracEtaty ON WPE_PRAID = PRE_PRAID
where WPL_Lplid = 936 -- tutaj wpisujemy LPL_LPLID z tablicy CDN.ListyPlac
AND PRE_DataDo = '2999-12-31'

GROUP BY PRE_PRAID,PRE_Nazwisko, PRE_Imie1,wpl_wartosc
ORDER BY pRE_NAzwisko, PRE_Imie1