CREATE VIEW suppressions AS

	SELECT 

		abs_view.id_personnel , 

		abs_view.total * base_salaires.base_horaire 

		AS total_suppressions

	FROM 

		abs_view

    	INNER JOIN base_salaires

    	ON 

			abs_view.id_personnel 

			= 

			base_salaires.id_personnel