back to first page..
back to River basin district

drop table if exists ccm21.riversegments_Basque;
create table ccm21.riversegments_Basque as (
        select * from ccm21.riversegments where wso1_id in (select wso1_id from europe.wso1 where area='Basque'));

drop table if exists ccm21.riversegments_Western;
create table ccm21.riversegments_Western as (
        select * from ccm21.riversegments where wso1_id in (select wso1_id from europe.wso1 where area='Western'));

drop table if exists ccm21.riversegments_Brittany;
create table ccm21.riversegments_Brittany as (
        select * from ccm21.riversegments where wso1_id in (select wso1_id from europe.wso1 where area='Bretagne'));

drop table if exists ccm21.riversegments_Rhone;
create table ccm21.riversegments_Rhone as (
        select * from ccm21.riversegments where wso1_id in (select wso1_id from europe.wso1 where area='RhoneMediterranee'));


drop table if exists ccm21.riversegments_Anglian;
create table ccm21.riversegments_Anglian as (
        select * from ccm21.riversegments where wso1_id in (select wso1_id from europe.wso1 where area='Anglian'));