SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
create view [dbo].[vw_nm_variables]
as
	/*

	DGE: obtenir la totalité des variables (réelles et sinistres)

	*/

	select	nmpv_variable_code,
			nmpv_l1, 
			nmpv_l2,
			nmpv_l3		
	from	nm_products_variables
	union
	select	nmcv_variable_code, 
			nmcv_l1, 
			nmcv_l2,
			nmcv_l3
	from	nm_claims_variables

GO
