Index: trunk/SQL/Views/EmisjeReklamy.txt
===================================================================
--- trunk/SQL/Views/EmisjeReklamy.txt (revision 349)
+++ trunk/SQL/Views/EmisjeReklamy.txt (revision 349)
@@ -0,0 +1,25 @@
+
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+
+ALTER VIEW [dbo].[EmisjeReklamy]
+AS
+SELECT 
+U.Id AS EmisjaId,
+R.ReklamaId,
+R.idZamowienia AS ZamowienieId,
+N.TYT AS Tytul,
+N.NRW AS NrWydania,
+N.DATA_W AS DataEmisji
+FROM [Uka¿e siê w nr] U 
+LEFT OUTER JOIN Reklama R ON U.ReklamaId = R.ReklamaId
+LEFT OUTER JOIN NR N ON N.TYT=R.[Tytu³] AND N.NRW=U.[Nr Wydania]
+GO
+
+SET ANSI_NULLS OFF
+GO
+SET QUOTED_IDENTIFIER OFF
+GO
+