EXCEPT差集运算

时间:2023-03-09 18:38:00
EXCEPT差集运算

  EXCEPT差集运算在逻辑上先删除两个输入多集中的重复行,把多集变成集合,然后返回只在第一个集合中出现,在第二个集合中不出现的所有行。可以看下面示意图。

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAdUAAAFqCAIAAADDR1cAAAAbEklEQVR4nO2c25XrtrIAlaDzcBaTgCNwGCdB3o+5S9YWSRCPfqPqa6whgAa7UWxxbL8OAADw4OUdAADApuBfAAAf8C8AgA/4FwDAB/wLAOAD/gUA8AH/AgD4gH8BAHzAvwAAPgz49wUAAOPgXwAAH/AvAIAPkv7tHwIAsC34FwDAB/wLAOAD/gUA8AH/AgD4gH8BAHzAvwAAPuBfAAAf8C8AgA/4FwDAB/wLAOAD/gUA8AH/AgD4gH8BAHzAvwAAPuDfCryu8A5qmKGwa2wZNgf/FuHrzvsmYm710VGhtgwwAf4twvvOR0jBRAyv1+vff/+daIFXFgXwBf8WoeHf30/+/vvvu6/qPZ+/f/X7819//XU56nXiMs7Lz1f8S+FBRvBvER6t9/fffx/3dm7/fPmrhvsaZTDk37PNL8Og6iAp+LcI7zt/l4LL7PSI8lJ8f/31V2OSiTK49O/jkMYzACA++LcISv69+5Wsf+9E3zNqelEAd/BvER7vfHz/jo7Fv5Ad/FuEtoze/9h2ZcODX7+a9u/jYwD/wj7g3wq8rjj/9p9//mnor/355YSNjN/9qjO8xypqbxkgBY+li3/hm9ef/S8AzIF/YQz6TQAp8C8AgA/4FwDAB/wLAOAD/gUA8AH/AgD4gH8BAHzAvwAAPuBfAAAf8C8AgA/4FwDAB/wLAOAD/gUA8AH/AgD4gH8BAHzAvwAAPuBfAAAf8C8AgA/4FwDAB/wLAOAD/gUA8AH/AgD4gH8BAHzAvwAAPuBfAAAf8C8AgA/4FwDAB/wLAOAD/gUA8AH/AgD4gH8BAHzAvwAAPuBfAAAf8C+AP68FvGOHefAvgB0rnkXK9cC/AFqY2bYH75sBFzxmB/+mh0Nrif19Jq15ecwI/k3D3Mnn9K4T8NYFDAnOPGYB/wal/4AZ4H0zfMh1W3JFuwmPNx//BsJYjsbLZaHAHcgefxke7zn+dSag+AKGZEDJnZbcVCIebzX+9SGR3RKFOkfJTZ3ZZJuhwL+xyC6y7PF/UmMXo+y5ay/wbxTq1X3eHSUNWxZuggH41xkNSf38/MgFKDB5IhGnCNIY7oke+NcNDSX9/PzoyXd98sgWDhtYELg/GuBfB5RKudOPcxqVNXsoEceJJD7cK1nwrx2q2u2X79z843F14Xuesckc3Dcp8K8F2uYdul5p8hXszzMGWYd7uA7+1UWvRofMOGHq8YhWMTvPWEMQbuYK+FcRPfMqtb2WPe8dqucZWSjBjZ0D/6qgV44TLxD0/ijXmG1xBo0biCC04Q6Pgn+F0W4E7tT2c6J/wkVdnpeWUrnUzdROCrzhVg+BfyVxlO/EVIuuNHtZsXhL0YE93PNO8K8MBub9Mt2KQBe9af+aeO72YgFfuP+P4F8BDMz7KzuRL/gpet5Lhu4zhz8CZKEN/l1iri/rQeOl6kqz7KjdTzpvOMc+DuSiAf6dR6+wPk0nKL6heWSdK+vuxp3ntMeEvFyCfydRqqcv5UkZcHQewUWVGufL+88hjwzZOYN/h9Eoo0tVCb5z6J8nbM97yese7aVhAnL0Bf4dQ7yA7nxn3PaKN6pm7TbmTQfJeoN/B7g75z8LXC60qMIhmcpq9z1n/9LrAaDgdJCvX/BvF2blsu6joeHi5u2ZU7DXPpu3cBEWg3wd+LcHS/mujB3teb3k+xXDdBjnvHCkc0G+8O8DNiWy3vMOLSRr3k6T/vneZTWAu7xwpHOxeb7wbwvt4lj00ehY8Ya3Z/XPIKUCaOdl8yOdjp3zhX9vMSgLM+1K9bxDPeznNYIxdCZl2yOdlD3zhX+v0auGla/hE6NktTt0/fnndYbysueRzsuG+cK/FyjVwZyJpn0t2/OOXizY8L6ZyMuGRzo1u+UL/34jWwHTre7ncJtRK/P8nFhf/SuA6bzsdqSzs1W+8O8fCOZ+UUPpzLu+6OXkvz8s5mWrI12AffKFf/9DVr7Gw43Nu9Lqtgdezryemn2OdAFef+IdjiL49/8Ryfd6MzgxXNu853cLi/IdDUDqKG5ypGuwSbLw73FIJFtEu/0zrBiwZ+nz/CK7a8v38nPZc7jJqa7BDsnCv6tpdjHv9HLHqZ+9vGBlxdE2uXGNxgnc4VSXoXyydvfv6096hvSbpWeqoYs7Rdamf4k580pdr3f2yp/qStROFv4dzu6icyfmWRf94+TnJR5XHDL73di7C1RPXe0jXY/C+drav3Od7/q6/fMombchzUczTtj2cpL2Bdq1VPhIl6Rqsvb179AJLGbeu897el6RANrz2MgRBSeiarI29W9/OkV6vf6eUaS7bMy8spyUfNvXWJ60qqe6JCWTtbt/G9csenDUpErabcw89DyoJ9+vFW2WgxXqKXhH//Zkcd28etcPTfs1eb9PZaPqnMq+hOod6doUS9Z2/hU8bz83jA5fDONu5rtfrQyfjqfnMi8VouBEFEvWXv5dTN6cZ+8mmRveucTlig0pr++rM5g7fM9VsVNdm0rJ2tS/LquravdOoO0VbULqudi9eNwDgH7KKHgj/zrmzFhznc2sUkgTfXSEyilzpDehRrJ28a/L6dJ+1XDZ7fY0vNpRDV0fR3xxIoFHaiRrO//qLfFzwnKtzhWDvG34JFTZhAoG2hRI1hb+1XtU2tj2uPoT2cSKskGKPGyidTHR4oEGBZJV37/iSTJz7udy7U8aA5WilZotYM0UONX7kD1ZG/l3briqxXqWbn/SHq4Rj+BNiFkwR+DA4EzqZBX37+jj0d22X0tPB6MhX9kJI3cukWODL1Inaxf/Pl5pbNvz6l//OBeP+GNjccLG2IDV8knw8OCTvMmq7N+7B+O50zQ2793qK8GI76Jzwsub+XhjU/Qs8SOEX1KU0yVl/Rs5JUOq6pxKPLaea6bXDZuaTyKXEHyRNFP1/esdyHHovFa2b3ilgk/ktSxxQqKi+qSmf32TcWdbQWMuztPZfYs/M36JUyePJD3Ve5IxU8X9a7binW1F/CU11dBw2eb6TTqj5Yp2Z9KV1lHSv8ZpOBtNts8VFLfNom2CFEk/GU/1tqTLVGX/is/8+LVdxFwrfe5im6xq3iOtyzLGvCfpCgz/3tJQ7aWIF821OImU+hdnaBOkQkZJd6p3Jlemqvl3IoZ+mYp49m7RxXlE4lmcpE1qi+WNfDdylRn+7WVdkeKdspQxDeR7xCiPaVIHvxuJklXKv+IBiJtuEfFILHfnXh6LZI9/HxJlCv9eEMq5h1o84u9SGte418Y6BbawD1mSVce/d6tffv1v4xH+N6rxCM7cOUmW89Cmxi52IEum6vs3HarPACnzDs3z+mBxXV9q7GIHspQc/vVBu/tWmn9unlypaZDlVMORpOqK+DfFvT6s3iy/l1gxr6C7s2Snh0p7qU2KTOFfC2y0e5zMOz2DYKjFesZKeylP/GRV8G+cE67xlX9o6WPZvKJBHUeGMzBEnGKDR+JnqpR/jdf9xcyzd3L/Mm9/GDYPifhnYJR6O6pK/Ezh33nMetuj+a95DQnUuCuPfwAmKLmpqgRPVnr/2n8ftPTX8WT5Ue0KBdVL8Oqfpuq+6hE8U3X8Kzjn4zd9VTqXG+p5hUIbni149U9TdV/1CJ4p/PsHLk3iMfhaoOcy8QfGxIT2X03MqLqvkkROVm7/Cp5wM/Mu9tSPHbH4RqYnjFz3ixR+tNQjcqaK+HdlEmPzzo1qi1VjC0Mqv7w4ct2vU3t3lYicqU39q9QqnidfWehu1PrMj4t2Ttu+OHLdr1N7d5WInKlq/r1zn56wzutKTXi3isj8X3NOBN++OHLRi1B+g5UIm6zE/n19YLPiFxrOvZtQz7zTY9sXhK14KdzLD/oJm6kK/rVZ7lD7D8YuJ9Rr2Bfn7BwbtuIF2WGPNQibKfzbi5IE39PqCfdyuel5Oq8MW/GC7LDHGoTNFP695ueE7MznJaTm/1xFavLRecKWuyybbLMGMZOV1b+vD94fnqU5jUbMlkvIzjk6JGata7DPTrMTM1Pp/Wuw1ijGWj90tHss/IEucnZk2Wen2YmZKfwrg4FkG0tHmzZadvTYZ6fZiZkp/LuEo3O132OsDA+SHQP22Wl2YmYK/05i3PDmeo/hnh0z9tlpdmJmCv/+R+O97SWCSz9GZbOQyDwxC12JrTabnYDJSunfxYWmfWr8qsG+uRaZLWCVq7LbfvMSMFNl/SvVt9o3vIeyebUb+YBVrspu+81LwEyV9W8/DVNbOvczGI05zXYUsMpV2W2/eQmYqa3962LYz6WVdO/7CAlY5arstt+8BMxUWf+2u1pH8x5q/8bu4fpEeROwylXZbb95CZipsv6NhoH33c37S8bsrLDbflMTLVP4VxipXrunfw/Szn8SOTVKbLjlvERLVj7/vj5QXWiCdQ+GkukEYVOjyp67zki0TCX2r+oqoyxKM7t238TMjjZ77joj0TKFf5dY9GZG7bZjDpUdM/bcdUaiZQr/9iL1yjXaG9tLpt8yR6tvG/bcdUaiZQr/PiCl2vjOPST68Wj1bcOeu85ItEzh31avN22i+Kp9I/tsiFbfNuy564xEy9S+/tVoSMM2ueIPmDui1bcNe+46I9EytYt/9bwT/92CZWDR6tuGPXedkWiZquzfITO230KY9Y+LuEcYrb5t2HPXi7yuMFtUe6FOyvo3mhkNiLDlaPVtw567XufrpsWxhxlF/Bu8LVUl1Jaj1bcNe+56HfxbxL8rU63PY4b764VHotW3DXvuep3Pm2ZzA6NlCv9GyUSDmKq9JFp927Dnrtd5/YnligZr9bCvf1+v17///hsqGb8E73DbRKtvG/bc9Tr0v/jXMxnx3yeMEq2+bdhz1+t83bRE9pAC/1ono4xqL4lW3zbsuet18C/+NUpGYed+Eq2+bdhz1+vg3039+zohFd4vxd4q9G8nWn3bsOeuFzmfQYMbGC1TW/v3/PMoly9wM9r2biOjO4pW3zbsueuMRMsU/h32bxbPPipVaSPRStyADbeclGiZyuff9YXew//555/XB5cXx+xt7a3aP3+0EtfmsYQgCAHTtKN/M+LyDJhbdLfs7LbfvATMFP51xr6T7Q9sbmCl7PSw237zEjBT+NeTIG8zvlg0fpnsdLLbfvMSMFP41wGXrraz0V6PKnt2Rtltv3kJmCn8a0r8t7fr5M3OHLvtNy8BM4V/VfB9jev1yviX+NmRZbf95iVgpvCvJI5/LnNf/ZOwCdJgq83mJWaaUvrXeK1H3MXn9Tb57rehsqPKPjvNTsxM4d953LV7RH2hHCE7Nuyz0+zEzBT+HcZduwYvlBdfXsesdQ322Wl2YmYK//ZSVbuXql1cImata7DPTrMTM1P495kg2tWbXHzamLWuwT47zU7MTKX3r+pyXuZVfcNg8PriiFru4myyzeyETVNW/6ou5/iqQXBdjRcL/YSteEF22GMNwmYK//6HsaGU5Giv2kvCVrwgO+yxBmEzhX+Pw+nfn0038xBhK16QHfZYg7CZquDf0RW9vpJrrGi/l/6Fwha9FOU3WIPIaUrs34kVtd3XRmrdzwDE5/ycfHEXket+ndq7q0TkTG3hX1kDmnWax5PiVddanzBy3a9Te3eViJypsv7V8JSZdlXXMhP66wPZmSNQeGvFiJypIv79WlSpN5Sd83IJ7eba7PnxS+TSX6H2o6USwdOU279fi4rIy/6bvqXcxSdsbyF49U9TdV/1CJ6pUv5dRNuDNqr9WktPuz3XB6/+aaruqx7BM1XHv4/rXrZsspLSnr9/ab35RwcGPwBzlNxUPeKnKb1/Hdc1Nmw7hrDzxz8Do9TbUVXiZwr/9uJrW+OeWnCJ/i8oWSi2ncLEz1Qp/wouHaG3PQzbW8HNnofHPwb91HucVCVFmir4V2rpIG8StMNQnf9yzhQnoZNKe6lNikzt7l/3DvdQ+/cuNHrbx7Uuf1upZyyzkdpkKbki/h1aPYJzP5ENw3Jr/WulOAyPZDnVkCVNu/jX3bl33WhPPI2xNu3tXTD9o7KchzY1drEDWTJV3L9xnNt/pb1SO1kMJsuRaFBgCzuQ6GtKHf9GCODNo6piGvaMYJBxsjNH9vj3IVGm8K8wneY1imYB8TgTdSWXpA5+H3KVWSn/2sfQ/64gfqv7Ri/OCBUyR65TvTO50oR/r2m/kO2XaWTtTm9qmrwWSxr2bqQrsLL+7Q9Dw0GRtXu4vgOJUCSjpDvV25IuTdX82xOGUrtn00KuECG8jC5LF/CelCytxP49R6JhH3ep3b1GsHyxMESQOukk46nek4xpKuhfm0h8pRbQqv3kMlqiUDcnY6aK+1c8GBvrZelkv+gPL06ptMn1qNiZpGmq6d9DIhgb8SXS6yVzkWfxWoog4Uibqfr+HY3HvsNVXUgQ2UdFqGq5JMtDAvKmqax/j5H/Iw8d7iPTMd8NjG+34OHBL/ELqUFl/x7N/ymP9tJ5Vftm/YHRHhiwYN5Ejg0+SZ2pXfyrHVXqDlfpq8DjJGE7l7CBwRfZM1Xcv4daVBltq+TZxkKPV8Y8PwFDgjMxi2eIjfy7Hlg64b4xi3lioWhlU+BUb0KBNNX377F2ojL2uZ9Yhj23UDTfhQoG7ohWNnNs4d9jKrZcwjV7t9AIYHpsnMqJEwm0qZGp7fzbGV4i+fqGKiL6IL1MkDDgkTKZ2sW/R3fOEr1qiBCnVAARTpR7ANBDhFKRYiP/Ht3/a0rDiOaJ0PPKxuB7ruJXL/xSKVOb+vcyyDjyvXuZ6/6XwOmlO4P3KqFKLVVtimVqL/8e8fIXx61tJgKb2JRLdqKVBNxRL1Pb+fcIk8Wwqv1k+pEwvTv77EQoBngkyLGVZUf/Hq6hRm5yf1lvxhd3Z3nSSp7qkpRM0+7+NYs2/nvbzwgX297OgY0rbbKDfLNQNVOb+veQzujla9zFLlI2qsfL7v5xdK2hIXe/MjhvVY90PQpnal//HnX/u+Qh7c49KlZ83bmQ6qkrfKSLUTtTW/v3GMyusXDv/PhI/4TTwXx+PrGpzouVzt7rTwRnBlnKpwn/XiR41Gvr6C23PvPlkOmphq4/dE5g+VNdgx3StLt/D+8065l9XeV3w1d654kwZBO0w6kuwCbfUfDvcZicSe2een3mnhmk2uchBI/iDke6BptkCv/+P3r5VupwZVXeM3xOvlPhfCOSnU2OdAH2yRT+/Y/1rBt3uCLa7ZlEu+3tCWMxO/sc6exslSn8+wdzuRdX7Xnm9+Qra825W9W8Q0tMn8ytjnRqdssU/v3GsQJ6/DiktsVOeWKgdqc8kZ3djnReNswU/r3AoA7Oqr2z7ZxDF4WrrdHjqrU/X3D5+VB2NjzSSdkzU/j3Go1qGFXbhEBXBqr2yEMPksdrXn/Sc1k7PPBl20zh31ukamKudZ1rPy0Hvod3LiE756OCtz3Sueh8lFYF/7aYKI6hRu9y7Oj1i33rnHaPvmjnbkLnlY3s7HykE7G5fA/8+0hniSy67Jj6w9rKWivDj6doV54KQ9efs8ORzgKZOvBvD6qFotohrq81F8B0Pz4RzOueidnABjL1C/7tQq9cRqWzIt+5gV+TiMt3yLx3VyLfRJCpN/i3F40Trv3OYf0l7+jqEzs6D2lMgn+zQ44+wb9jCB7yTlXNCVTEuUNTjbaxlxe3N3v5+dm8O9RhRsjOGfw7zHoZDRnNy7yjq69f2V6uR76Xn0AEyMsl+HeS0XoSfBXQmFnqPcNoJ7v+OBn9VaPbbfwKXCAdd+DfeXqqSsm5n/NLzTMX5+OQnplHpdxz5znzESALbfDvEnetlqp2ZVvplXk62965C0bb3jMcfl+4/4/gXwHOdaZhXlmnr8/22NI+LnH327uBQ/K9G9UzBBaZy9SG4F8ZtAtOUOjrEu95n9Bp587PF28vOjCDWz0E/pVksfJ+7lmPTWQqKfM2fnv+UOQ84wUDuMmj4F9h5kpQ8MXC5cwi2u15mfAo3/bwrw/FzzOCUIIbOwf+VWGoHFXNuz5D5ySPl91dcLmK6nlGFrJwM6fBv4o0zrnsu4XLaadn7p9hvS82Nm9jFep2Au7hIvhXF4NzLuLcz6mkruy85v2zvROx8BzcNynwrwVK9SrVQY/OMyrWx2t8zzM26Yd7JQv+tUOqdmW73YlJ2kOGWuM45zlOJDHh/miAf625rOP+mybS8B4L/4v0x1e9nZPEPM8xo/KFe6IH/vXhzsIGd2/C4J2d8uMFjrseIkWQ2nATDMC/zlhW+fTbhp4XDu1rMh7mLE8LcfbctQv4NwSNo75+P1fe8668cFDdlBkFttDJPjuNA/6NhZSzFv9G1zP27oIa2j2z4b68Q6sP/g1K+7Rr3+RRa/tGa0yBnRbYQg0e7zn+deZRbfa3PWBILuTafq5oN+Hx5uPfQPSLT/BcGS+XkYA3J2BIcOYxC/g3KP0HzADvmxEIl7tHvpLymBH8m4aJkz+H90bTYJaRHrxvBlzwmB38mxsObSgW00HiivGYL/wLoAuq3Rb8CwDgA/4FAPAB/wIA+IB/AQB8wL8AAD7gXwAAH/AvAIAP+BcAwAf8CwDgA/4FAPAB/wIA+IB/AQB8wL8AAD7gXwAAH/AvAIAP+BcAwAf8CwDgA/4FAPAB/wIA+IB/AQB8wL8AAD7gXwAAH/AvAIAP+BcAwAcV/wIAQD/4FwDAB/wLAOCDgH8BAEAQ/AsA4AP+BQDwAf8CAPiAf8uy+JeBibXan9wNEQxjPSoAS6jFsvQbUHy5npmHrj9f/PgUOV/zv//9T+nxAzAH9VeWR8GJCOjShhNyfBw1FO3l3s8/APhCFZbl7KAvu2loqGfOs2H7R00E0/9UADCGKizLnWfF/TukudfNewANOd5NhX8hCFRhWd4ue/vu6Hgpsb7ixJWjA/tdr614gBWowrJcOq7Hev2Gagtu2oxf119+3hNhe4OPuwPQhiosy9syn/I6/3w3cNRQQ0PWZdo/pEfxAC5QhWX5cs3lz1IaGp2qbcbL2T4//NrIaFT4F4JAFZal32LrCzX+pPYYW2cYd859XGUoMABLqMKyfAmr7eLz552GOl/Z05P2MDqwJ0LMC6GgFsvy5Zqzp9b9O6T1xkI9KzYuOP+qS/C4GLyh/sryKEclAfVM+6m/rx/aj4TRgL+G4FwIBbVYFrMGcGiVu086Lxjay/lDqS0DiEAtAgD4gH8BAHzAvwAAPuBfAAAf8C8AgA/4FwDAB/wLAOAD/gUA8AH/AgD4gH8BAHzAvwAAPuBfAAAf8C8AgA/4FwDAB/wLAOAD/gUA8AH/AgD4gH8BAHz4Pxwx/qdc+J9vAAAAAElFTkSuQmCC" alt="" />

下面是一个简单的示例。

USE TSQLFundamentals2008;
GO -- EXCEPT差集运算
-- 以下代码返回属于职员地址,但不属于客户地址的不同地址
SELECT country,region,city FROM HR.Employees
EXCEPT
SELECT country,region,city FROM Sales.Customers;

查询结果:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAeQAAACkCAIAAADJ48p2AAAQaklEQVR4nO2dvW7bSBtGeUMODKiKqtyCAaXejn2KxK0vYIG4MGywcxGkSuUEql0GMYvFQoALw1WArzBS2MDuIh2/ghI15PxwOByZ81rn4IEjKeTw5ZA6Ho0kM1v99Z0QQkiaOTk5+e/ff/77959s8lIIIYTY0pV1tQdM3umEEDI0LVnvicjevHkzeQ2EEDIoW1nvianrfZ56cP+sTN7hhJDx2VNZ79Xgeq92lpCXGi9Z50VpzCzvZvL98dxn3V/X19fX19dXbS4vP01ebZT93Z/fxIS81PjKuiirdYoqt0S0rIui7MwePDw85EUxebU72l9CiKwEjqz1MfUsL2ezlyDrp6en8ldV/qo+/3jMc2RNCEkiXrJWR503NzfN7evr6/rG79+/i6KczXLj6pnCmFqjNLJyyvr29rYsy5ubm88/HouiRNaEkEQyWNaNoKuqurq6qk399PRUFOXr169tLTSGHa9avYWhbdpkXZTl1dVVUZSXl5/qIGtCSCLxkvXl5afb29ubm5vrNrXa6jfiXoCsO3PWn388rofYZVmU5f39vbuquowoY//oxxhZEyI9vrI2jqyLonx6eqoneS8vP7llrVus80hntsSmP2MjjnaM+2yU9c+fPx8eHh4eHsqy+vzj8fOPR3VPZ7Pc4WtkTQjZacKnQX7//n11ddW8Hdcr61Xbs/pY2zFkdshaf6TXlTZZ39/ft140lGXt6arIi6K8ublx+BpZE0J2Gi9Zn5+fl2VZW6yZ2K1/NjO8RVEMmgYxjn9tg+hBstbb0ffZZxpkLeuqqqrq/v5+luezWe5+E9W4C+5Rv08/OFZ0LODeX0KIrPjKWp0QqN9RfHp6urz8VP6q6kmD8/Nzm8hWfuNoz4V9ZO1+3CHr+oXCw8ND+Wsj6yKv8ryqqryYFUU5y62y7vz03Guf1xODbnjuLyFEVgbLup76aOapm+ldh6zVEZ9xUNm5axswdtA34Wins88OWdemLn9V6lj76enp/v6+KF0fT1yZZG3bI1vxxp7Rl/Fs2bG/hBBZ8ZV189kPdeqj/hDI+QbHyDqpOGTdmLosN7LO8yqf/fz5My9mAbK21RA2oHas7vgvZE3IC4ivrF+/fj2b5Z2f6o2ayffHc597ZF1WeTlrPgPz8PBwe3t7fX3t/uLPSpP1yuPVQ+/rid5lHO049pcQIiv81b116s971F+NqbOWdT6r8tnNzc0snzlkvdN0HB1lfwkhsoKs16nfPPzjjz9meV6nlvX6SzGbyZ+ppnpso+bg/SWEyAqytqZWs57J69/R/hJCUg6yfvnZt/0l5EVmf2VdAQBIoB5s7aOsCSFESppXxmZZnwAAwHQ0Qj7plfUbAACYgtVf34fJeqdTMLtrPJgUqkqhhmBEFw+QDiGy3t0UTFNTIkmhqhRqiFI8AIxhhawTryqFGqIUDwBjWCHrxKtKoYYoxQPAGFbIOvGqUqghSvEAMIbVXsj667vDV++Wk1QVuunBNdQbGr25uEHWALFYIevJqtpFDcga4IWySl7WH99u/rbc27ONj9YPHF109KSMLo8XzVpfjl9lWZZl6/86elvfXXysN3GxyA7ffxlQ1baRo4ttMQfHXzvlNVt8t7SUrRQ5umfUXatb9thBZA0ghcRl/eX4VSOyj2+zg+Ov20eW7w+yxUezrFWzd415cPy1vnF0sW62vjFE1ms1fzl+pTj61bulWnBr06ayO0WO7JkzfU/7dxBZA0ghbVnrFrOMo30fUf7rYpG9Pfu+OjtqRqCDq1IH0fXg+syyaZ8io/TMwB1E1gBS2F9Z1xa7WGyGxoGybg9abZueQtY+O4isAaSQtqx9pkHUl/lnR5m/rOs5X+fbcX2ibE96ZEcXg6ZBxsi6dxrEbweRNYAUEpf1d9cbjBsNLd8fbN7QO7AMWutGji7aWux9581jVNuU5/0Go/5rI0TWWs909tRvB5E1gBTSl/Xu0v/O26iqIk0Wj6hhyrcW9eIBYAyrPZX12VGW9Y86h1e1He1ux9qT9IzfDu46yBogFqs9lbWcqlKoIUrxADCGVYCsu1cviETzrN5R+2GkUFUKNQSDrAGiMFjWO6Wqql1vIoAUqkqhhmAmPcMBXgiDZb3rF85ZliX4k4zJ1Cc5wEtgFSDrHZVSN/53emRZtqNd9keu8uRWDpAUgbKOPvhqGs+ybGo5d0lBNynUEIbcygGSIjlZT21mA4ysxyC3coCkSE7WjKyNpFBDGHIrB0iKiLIe9X25vpH1+SJbnBvvfvvQfL1bXeLv80WWHX74FkHWlpH13ek8y5fKne29Za7cqZZ5ls1P7yIcJ0sVLbbbtXF3Oh9bzoDWkDVAFKLIevPX/WPI2jKytsn6fNEY+duHQ2WZ80W2WCyi2NqmG0VTd6fz+Vy913Z1nucj9eiStdq0j4iRNYBAhI+sv304NPv424fDxfnf51FsbZ2zXuabEfMyn58uG2stc8XVd6fzfFktR9raV9btbfutMg5kDfAsJCfrgSPrbx8OTZMdtavtLh+EXTcbM9b/1lru6Gv94FhBDh5Zb6dH1PF+tn3s7nQ+z/N5fW95OlcW3S653Z/TvD3N0mktoHIAGEJysrYI0z5nvZ203np57epItrZ/GmStxo2l6+GzydWjbe2StWHKujNDU1e18Wz9guDudF5bVr3RXnJ9S52Pt7UWUDkADCE5WQ8cWbcXWYtZec8xi/Auo0M3d6fzfKmOZuend+pERFulI2ztN7LeOLRrcHWOZrNKp2r98UGPBFQOAENITtYWYbaHyOYBszKRvTV5hLG163PW7XcP707n+elmLF0p4+r1nXBb+06DNBMynZlrh3CRNYAEkpO17XPWrbG0ouXto5uRdUfP423t1M0yzzqf2ctsHhtja19Z67ZW5jK2kxsOWRunQbq7pLUWUDkADCE5WdudqUxuKPY9XzQv9rUP823X0+ZMhuD8BmNHVuoMrjabqw94Bx4n8/ZbG2m2scybOZDOG4z1hwytslaXbD9uXmbOyBrgGYgo61HhG4xuUqghDLmVAyRFcrKe2swGnCPrZ0Ku8uRWDpAUycmakbWRFGoIQ27lAEkRKOvwqzzZYWTtQK7y5FYOkBQhsjZeuikKjKxtpFBDGHIrB0iKEFnvOlkC1/HSf5LgTH2SA7wEVqld1mtHjY8hhapSqCEMuZUDJEWgrKMPvnb9m2AMKVSVQg1hyK0cICmQdT8pVJVCDWHIrRwgKZB1PylUlUINYcitHCAp4sj6ovnO9+LjbmTd+Zv6yl3lL8y1vsod42Jaah9pJHFZr+ZL5d0/kpoMyBogChFkvXx/sHH0l+NX2duz55S18vc3dnAxLbWPdJK4rJeykbQkvQFZA0Qh8jTI8v3B4fsvzydr6x+yi3MxLbWPzEVNflmvbSnIGuAlE1fWzz+ytvyFzkgX01L7yFXVhJf16lSyuaNNimwf067L1RRtvsqXqbWIlQOAFzFlvXx/kL16t3zmOevuH/RcPxTlYlpqH5lI4LJeaywja/0qXMpFvbRrdxmv8qW3FrdyAPAimqzHmHqcrJXHtAu+th0+qo+MTH9ZrzXtDjFcG9euXfeFY/TWIlcOAF7EkfVIU3vIuu0b8xBPmciOdDEttY/MTH5ZL6UO5bMo7avljpK11lrkygHAixiyPjvKRlwjxk/W2qTsRsu6oyJeTEvtI3tdk17Wa7thtYj2nIfnNIhV1p3W4lYOAF5EkPX2Q9ZZlmXZbj4NUrVejbevo9V+9yvmxbTUPnJUNeVlvbbbbY3htbkX+xuMjtmPZhKbaRCAqYkzDTI+fIMx/RrCkFs5QFIg635SqCqFGsKQWzlAUiDrflKoKoUawpBbOUBSBMo6/OJddpB14jWEIbdygKQIkbXxilxRSPOJnUJVKdQQhtzKAZIiRNaE+GfqMxzghbAaKuupCwYA2EeQNQCAAJA1AIAAkDUAgACQNQCAAJA1AIAAkDUAgACQNQCAAJA1AIAAkDUAgACQNQCAAJA1AIAAkDUAgACQNQCAAJA1AIAAkDUAgACQNQCAAJA1AIAAkDUAgACQNQCAAJA1AIAAkDUAgACQNQCAAJA1AIAAkDUAgACQNQCAAJA1AIAAkDUAgACQNQCAAJA1AIAAkDUAgACQNQCAAJA1AIAAkDUAgACQNQCAAJA1AIAAkDUAgACQNQCAAJA1AIAAkDUAgACQNQCAAJA1AIAAkDUAgACQNQCAAJA1AIAAkDUAgACQNQCAAJA1AIAAkDUAgACGybq5TQgh5JnjK+tpf6sAAICXrAkhhKQQZE0IIQJilvUJAAAkRlfWbwAAIEm6I2sAAEiQlqwf//cnIYSQBIOspebk5KSqqsnLSCF0RSIRdyBkFYyspUbWeUZX7EPEHQhZBSNrqZF1ntEV+xBxB0JWwchaamSdZ3TFPkTcgZBVMLKWGlnnGV2xDxF3IGQVvHeyzjIZu9lbZ6zzbKoO8d/us3UFGRlxB0JWwS1Zq9hWyLLuYra7+sKeLQ965DH0aa83MnTHh67l7kD1hs9+6eeZu1n99tDe8+8rzwPh36WDusLdrG1Dxp7R1xraS8FdFNyxPtt17OygR9wHIqyR51zLp+B0YhhZ+xSqnuKOBx03bA0+Ks/k3kcehzwl9KPo2Lp7df+19H03/uzc8GlWN1TvgXAvMzTjVxzUpUO7Qv8Z0BUje2kXz/lBT8/e//XvH5+zvfecHPpE2/VaPk+idBJT1r2d5WM042Lu3g+QdUBrsWRtvB1X1saWw4r378+AFXcka58dHCTr5/99NrJNcbJ234671qCCk0pX1rpEGhzHW/9f4yPqs6LTcq/IbFv379bxstb3wqcG/w50L9ZJsKx9ijF2u6M/HbvgWNGxLZ9HbF1hO9y9R9y4Uf281W8Yu1TfYu+O9y7Tu5Zj3x2L6b1h6x/38ZU+su5d3ngOGI+dXobtKPjHJWtH9MV8OsvdBYMa9+xZx2K2Nn1a8z8bbPtu6xz3s06Np6wfh//CMz6H/fuztwMdpXou4O4Kn0Y899dtruAbtidz7w3Pbvc5i9znfxT3CZW1zwnsPgru4xuc7huMnqv5PBMGGdBTx0Ofxo7FnlnWvVtE1u7Vo8i60ye9TyefU9Ffsp0t6ltXl3G0o5fUOcS2ZfyP/t7K2v/p33tW6M874zPRP2ZZ+z/f3E/ysCewz+kytH/1xdzqDKswoK86rTmK7CTWG4w+qw/qzzEnj0839naFf28/tp8/PvX4nOS9N2yy9u+oQcv475Rxmf2RdZhJeg907+qeGfbRPccvEP2Rzv/6PIc7i9latm3Ov5d7t2U7JL1rOVbRu0U/ru4C1PR+6qiz6d6C9dr01R0HwngyDD0QjpajdIXj2GV2bMe0s4x7i8bl9SPeaU1v2XbXUbmxTtsyY8724I/u6Xd3t5ajYGPP2I6+8fFObcZiHPW4M+xLMSM3lkKkFN9bp6zP8485EDvtCunnc1IRd07KKnjvvsH4YiLrPKMr9iHiDoSsgpG11Mg6z+iKfYi4AyGrYGQtNbLOM7piHyLuQMgqGFlLjazzjK7Yh4g7ELIKRtZSI+s8oyv2IeIOhKyCkTUhhAhIS9arv74TQghJM1tZnwAAQMLUsv4/mU8gJ1I87VkAAAAASUVORK5CYII=" alt="" />