Tekil Mesaj gösterimi - Sql group by

Konu Sql group by

02-12-2014, 09:24:25

Merhaba,
Aşağıdaki kod ile istediğinizi alabilirsiniz sanırım..

SELECT TBL1.STAFFNO,TBL1.NAME,TBL1.SURNAME, SUM(TBL2.WAGE) AS SumWage
FROM  
BY_001 TBL1 LEFT JOIN  
BY_001_01 TBL2 ON  TBL1.STAFFNO = TBL2.STAFFNO    
GROUP BY TBL1.STAFFNO, TBL1.NAME,TBL1.SURNAME