Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- 1. Сколько работник заработал за указанный период / время * тариф
- */
- SELECT ss.IdPersonFK,
- SUM(ss.DengiRabochego) AS Dohod
- FROM
- (SELECT listBrigade.IdPersonFK,
- listBrigade.executHours*listTypeWork.DengaDen AS DengiRabochego
- FROM listBrigade
- INNER JOIN listTypeWork ON listBrigade.TypIdFK=listTypeWork.TypIdPK) ss
- GROUP BY ss.IdPersonFK
- ORDER BY Dohod;
Add Comment
Please, Sign In to add comment