USE [Wina]
GO

/****** Object:  View [dbo].[Wszystko]    Script Date: 2017-03-25 12:32:03 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[Wszystko]
AS
SELECT dbo.Faktura.IdFaktura, dbo.Klient.NazwaKlienta,
 dbo.Klient.Miasto, dbo.Towar.NazwaTowaru, Ilosc, dbo.towar.Pojemnosc, Kwota
FROM            dbo.Faktura

INNER JOIN
                    dbo.Klient ON dbo.Faktura.IdKlient = dbo.Klient.IdKlient
                    JOIN dbo.PozycjaFaktury as pf
                    ON pf.IdFaktura = dbo.faktura.IdFaktura

                    JOIN Towar ON
                    towar.IdTowar = pf.IdTowar


GO