Index: trunk/SQL/Views/ZAMOWIENIA_NETTO_ZAFAKTUROWANE.txt
===================================================================
--- trunk/SQL/Views/ZAMOWIENIA_NETTO_ZAFAKTUROWANE.txt (revision 420)
+++ trunk/SQL/Views/ZAMOWIENIA_NETTO_ZAFAKTUROWANE.txt (revision 421)
@@ -6,10 +6,12 @@
 
 ALTER view [dbo].[ZAMOWIENIA_NETTO_ZAFAKTUROWANE]
-as
-select Z.idZamowienia,round(sum (U.netto),2) as nettoZafakturowane from dbo.zamowienia as Z left join
-Reklama R on Z.idZamowienia = R.idZamowienia left join
-[UKA¯E SIÊ W NR] U on U.reklamaId = R.reklamaId
-where u.status<>2 
-group by Z.idZamowienia
+AS
+
+SELECT Z.idZamowienia,round(sum (U.netto),2) AS nettoZafakturowane 
+FROM dbo.zamowienia AS Z 
+LEFT JOIN Reklama R ON Z.idZamowienia = R.idZamowienia 
+LEFT JOIN [UKA¯E SIÊ W NR] U ON U.reklamaId = R.reklamaId
+WHERE u.status<>2 AND zafakturowana=1
+GROUP BY Z.idZamowienia
 GO