Index: trunk/SQL/Views/VIEW_RAPORT_ZMIAN_EMISJI.txt
===================================================================
--- trunk/SQL/Views/VIEW_RAPORT_ZMIAN_EMISJI.txt (revision 363)
+++ trunk/SQL/Views/VIEW_RAPORT_ZMIAN_EMISJI.txt (revision 747)
@@ -38,8 +38,8 @@
 LEFT JOIN dbo.[UKA¯E SIÊ W NR] U ON ZE.idEmisji = U.id 
 WHERE ZE.nastNrWyd > 0
-UNION 
-SELECT idFaktury, reklamaId, ID, [Nr Wydania], dataAnulowania, -netto, 1 as Korekta 
-FROM dbo.[UKA¯E SIÊ W NR]
-WHERE status=2 AND idFaktury IS NOT NULL AND [Nr Wydania] > 0
+--UNION 
+--SELECT idFaktury, reklamaId, ID, [Nr Wydania], dataAnulowania, -netto, 1 as Korekta 
+--FROM dbo.[UKA¯E SIÊ W NR]
+--WHERE status=2 AND idFaktury IS NOT NULL AND [Nr Wydania] > 0
 ) T
 LEFT JOIN dbo.REKLAMA R ON T.reklamaid = R.reklamaid
@@ -51,4 +51,5 @@
 --WHERE F.ID_SPRZEDAWCY NOT IN (4,6)
 LEFT JOIN FakturyPoznanKatowice FPK ON F.ID_Faktury=FPK.IDPozKat
+WHERE L.id IN (1, 2) AND T.netto<>0
 GO