Index: trunk/SQL/Views/FakturyNettoByTytul.txt
===================================================================
--- trunk/SQL/Views/FakturyNettoByTytul.txt (revision 333)
+++ trunk/SQL/Views/FakturyNettoByTytul.txt (revision 334)
@@ -21,5 +21,6 @@
 		 ELSE LOWER(AGENCI.Symbol)
 	END
-ELSE LOWER(AGENCI.Symbol) END
+ELSE LOWER(AGENCI.Symbol) END,
+K.kodKlienta, K.FirstName, K.Address, K.City, K.PostalCode, K.Country, K.PhoneNumber
 FROM 
 FAKTURY F 
@@ -31,4 +32,5 @@
 LEFT OUTER JOIN REKLAMA AS R ON R.ID_FAKTURY = F.ID_FAKTURY
 LEFT OUTER JOIN Zamowienia AS Z ON F.idZamowienia = Z.idZamowienia
+LEFT OUTER JOIN Klienci AS K ON K.CustomerId = F.ID_NABYWCY
 WHERE 
 (F.KOREKTA <> 1) 
@@ -52,5 +54,6 @@
 R.zablokuj_prowizje, 
 Z.ZP, 
-Z.procentProwizji
+Z.procentProwizji,
+K.kodKlienta, K.FirstName, K.PhoneNumber, K.Address, K.City, K.PostalCode, K.Country
 GO