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