CREATE OR REPLACE VIEW pj_j_statut AS
	SELECT plan_gestion.id_pg,
		plan_gestion.pg_nom,
		plan_gestion.pg_debut,
		plan_gestion.pg_fin,
		lst_pgs_statut.statut
	FROM plan_gestion, lst_pgs_statut
	WHERE plan_gestion.pg_statut = lst_pgs_statut.id_statut;