cnct_bioeco_soef20_3_3_1_EU27_NWFPs_tonnes

Select  [NUTS_CODE],
[nwfp_category], nwfp_category_short,
[total_tonnes]  from [FISE].[v1].[v_bioeco_soef20_3_3_1_EU27_NWFPs_tonnes]
  Union
  SELECT 'EU27' as [NUTS_CODE], 'Other animal products including hides skins trophies and living animals' as [nwfp_category],'Other animal products' AS nwfp_category_short, 0 as [total_tonnes]