| 8 | | as |
| 9 | | select Z.idZamowienia,round(sum (U.netto),2) as nettoZafakturowane from dbo.zamowienia as Z left join |
| 10 | | Reklama R on Z.idZamowienia = R.idZamowienia left join |
| 11 | | [UKA¯E SIÊ W NR] U on U.reklamaId = R.reklamaId |
| 12 | | where u.status<>2 |
| 13 | | group by Z.idZamowienia |
| | 8 | AS |
| | 9 | |
| | 10 | SELECT Z.idZamowienia,round(sum (U.netto),2) AS nettoZafakturowane |
| | 11 | FROM dbo.zamowienia AS Z |
| | 12 | LEFT JOIN Reklama R ON Z.idZamowienia = R.idZamowienia |
| | 13 | LEFT JOIN [UKA¯E SIÊ W NR] U ON U.reklamaId = R.reklamaId |
| | 14 | WHERE u.status<>2 AND zafakturowana=1 |
| | 15 | GROUP BY Z.idZamowienia |
