root/trunk/SQL/Views/ZAMOWIENIA_NETTO_ZAFAKTUROWANE.txt @ 420

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

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
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO