CREATE VIEW dbo.Vue_depense
AS
SELECT dbo.Depense.Num_depense, dbo.Depense.Num_exercice, dbo.Depense.Date_depense, dbo.Depense.Montant_depense,
dbo.Depense.Mode_depense, dbo.Depense.Num_piece, dbo.Depense.Motif, dbo.Vue_exercice.Libelle_exercice,
dbo.Depense.Beneficiaire, dbo.Depense.Num_famille_depense, dbo.Vue_famille_depense.Libelle_famille_depense
FROM dbo.Depense INNER JOIN
dbo.Vue_exercice ON dbo.Depense.Num_exercice = dbo.Vue_exercice.Num_exercice LEFT OUTER JOIN
dbo.Vue_famille_depense ON dbo.Depense.Num_famille_depense = dbo.Vue_famille_depense.Num_famille_depense
Partager