Advertisement
Guest User

vue

a guest
Jan 19th, 2020
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.99 KB | None | 0 0
  1. select "CODE_CLIENT","SOCIETE","ADRESSE","VILLE","CODE_POSTAL","PAYS","TELEPHONE","FAX" from clients_en
  2. where pays = 'Pologne' OR
  3. pays = 'Norvege' OR
  4. pays = 'Suede' OR
  5. pays = 'Danemark' OR
  6. pays = 'Islande' OR
  7. pays = 'Finlande' OR
  8. pays = 'Royaume-Uni' OR
  9. pays = 'Irlande' OR
  10. pays = 'Belgique' OR
  11. pays = 'Luxembourg' OR
  12. pays = 'Pays-Bas' OR
  13. pays = 'Allemagne'
  14. union all
  15. select "CODE_CLIENT","SOCIETE","ADRESSE","VILLE","CODE_POSTAL","PAYS","TELEPHONE","FAX" from clients_es
  16. where pays = 'Espagne' OR
  17. pays = 'Portugal' OR
  18. pays = 'Andorre' OR
  19. pays = 'France' OR
  20. pays = 'Gibraltar' OR
  21. pays = 'Italie' OR
  22. pays = 'SaintMarin' OR
  23. pays = 'Vatican' OR
  24. pays = 'Malte' OR
  25. pays = 'Albanie' OR
  26. pays = 'Bosnie-Herzegovine' OR
  27. pays = 'Croatie' OR
  28. pays = 'Grece' OR
  29. pays = 'Macedoine' OR
  30. pays = 'Montenegroe' OR
  31. pays = 'Serbie' OR
  32. pays = 'Slovenie' OR
  33. pays = 'Bulgarie'
  34. union all
  35. select "CODE_CLIENT","SOCIETE","ADRESSE","VILLE","CODE_POSTAL","PAYS","TELEPHONE","FAX" from clients_a
  36. where pays = 'Argentine' OR
  37. pays = 'Bahamas' OR
  38. pays = 'Antigua-et-Barbuda' OR
  39. pays = 'Barbade' OR
  40. pays = 'Belize' OR
  41. pays = 'Bolivie' OR
  42. pays = 'Bresil' OR
  43. pays = 'Canada' OR
  44. pays = 'Chili' OR
  45. pays = 'Costa Rica' OR
  46. pays = 'Cuba' OR
  47. pays = 'Republique dominicaine' OR
  48. pays = 'Dominique' OR
  49. pays = 'Equateur' OR
  50. pays = 'Etats-Unis' OR
  51. pays = 'Grenade' OR
  52. pays = 'Guatemala' OR
  53. pays = 'Guyana' OR
  54. pays = 'Haiti' OR
  55. pays = 'Honduras' OR
  56. pays = 'Jamaique' OR
  57. pays = 'Mexique' OR
  58. pays = 'Nicaragua' OR
  59. pays = 'Panama' OR
  60. pays = 'Paraguay' OR
  61. pays = 'Perou' OR
  62. pays = 'Saint-Christophe-et-Nieves' OR
  63. pays = 'Sainte-Lucie' OR
  64. pays = 'Saint-Vincent-et-les Grenadines' OR
  65. pays = 'Salvador' OR
  66. pays = 'Suriname' OR
  67. pays = 'Trinite-et-Tobago' OR
  68. pays = 'Uruguay' OR
  69. pays = 'Venezuela'
  70. union all
  71. select "CODE_CLIENT","SOCIETE","ADRESSE","VILLE","CODE_POSTAL","PAYS","TELEPHONE","FAX" from clients_rdm
  72. where pays = 'Suisse' OR
  73. pays = 'Autriche'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement