Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select "CODE_CLIENT","SOCIETE","ADRESSE","VILLE","CODE_POSTAL","PAYS","TELEPHONE","FAX" from clients_en
- where pays = 'Pologne' OR
- pays = 'Norvege' OR
- pays = 'Suede' OR
- pays = 'Danemark' OR
- pays = 'Islande' OR
- pays = 'Finlande' OR
- pays = 'Royaume-Uni' OR
- pays = 'Irlande' OR
- pays = 'Belgique' OR
- pays = 'Luxembourg' OR
- pays = 'Pays-Bas' OR
- pays = 'Allemagne'
- union all
- select "CODE_CLIENT","SOCIETE","ADRESSE","VILLE","CODE_POSTAL","PAYS","TELEPHONE","FAX" from clients_es
- where pays = 'Espagne' OR
- pays = 'Portugal' OR
- pays = 'Andorre' OR
- pays = 'France' OR
- pays = 'Gibraltar' OR
- pays = 'Italie' OR
- pays = 'SaintMarin' OR
- pays = 'Vatican' OR
- pays = 'Malte' OR
- pays = 'Albanie' OR
- pays = 'Bosnie-Herzegovine' OR
- pays = 'Croatie' OR
- pays = 'Grece' OR
- pays = 'Macedoine' OR
- pays = 'Montenegroe' OR
- pays = 'Serbie' OR
- pays = 'Slovenie' OR
- pays = 'Bulgarie'
- union all
- select "CODE_CLIENT","SOCIETE","ADRESSE","VILLE","CODE_POSTAL","PAYS","TELEPHONE","FAX" from clients_a
- where pays = 'Argentine' OR
- pays = 'Bahamas' OR
- pays = 'Antigua-et-Barbuda' OR
- pays = 'Barbade' OR
- pays = 'Belize' OR
- pays = 'Bolivie' OR
- pays = 'Bresil' OR
- pays = 'Canada' OR
- pays = 'Chili' OR
- pays = 'Costa Rica' OR
- pays = 'Cuba' OR
- pays = 'Republique dominicaine' OR
- pays = 'Dominique' OR
- pays = 'Equateur' OR
- pays = 'Etats-Unis' OR
- pays = 'Grenade' OR
- pays = 'Guatemala' OR
- pays = 'Guyana' OR
- pays = 'Haiti' OR
- pays = 'Honduras' OR
- pays = 'Jamaique' OR
- pays = 'Mexique' OR
- pays = 'Nicaragua' OR
- pays = 'Panama' OR
- pays = 'Paraguay' OR
- pays = 'Perou' OR
- pays = 'Saint-Christophe-et-Nieves' OR
- pays = 'Sainte-Lucie' OR
- pays = 'Saint-Vincent-et-les Grenadines' OR
- pays = 'Salvador' OR
- pays = 'Suriname' OR
- pays = 'Trinite-et-Tobago' OR
- pays = 'Uruguay' OR
- pays = 'Venezuela'
- union all
- select "CODE_CLIENT","SOCIETE","ADRESSE","VILLE","CODE_POSTAL","PAYS","TELEPHONE","FAX" from clients_rdm
- where pays = 'Suisse' OR
- pays = 'Autriche'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement