back to first page..

"id_roe" in ('ROE50534','ROE65180','ROE66096','ROE47382','ROE47384','ROE64290','ROE47361','ROE47363','ROE47352','ROE46580','ROE47341','ROE47362','ROE49696','ROE47348','ROE47353','ROE47342','ROE47350','ROE47358','ROE47359','ROE47373','ROE47374','ROE47409','ROE47412','ROE64330','ROE47356','ROE47357','ROE47360','ROE46281','ROE52263','ROE67681')

alter table "ROE-BV" set schema rht
alter table rht."ROE-BV" rename to roe_pate_bv11axes
alter table rht.roe_pate_bv11axes rename column "Id_ROE" to Id_ROE

select count(*) from rht.roe_pate_bv11axes limit 7

drop table if exists rht.rhtvs2_roe_pate_bv11axes;
create table rht.rhtvs2_roe_pate_bv11axes as (
select r.id_drain,t.dmer, module, module_icinf, module_icsup, minqmx, minqmxicinf, minqmxicsup, b.* from rht.rhtvs2_roev2 r	
	join  rht.roe_pate_bv11axes b on r.id_roe=b.Id_ROE 
	join rht.rhtvs2 t on t.id_drain=r.id_drain
	join rht.attributs_rht_fev_2011_vs2 a on r.id_drain=a.id_drain);