In SQL Server, we are very familiar with IN keyword and we use this keyword in many times which is very helpful for us. It save our extra efforts and code line like below query.
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAqMAAAHrCAIAAAB0HgOjAAAgAElEQVR4nO3d+28k2X3f/fo/nr8gvwQTTGdR0z/kr4gt/xIZYQ/qP3ggexHAi2wEQ0021A8cTUDZSlaAspI9yS5nnrBhWUZmf7WGgfzwMjJITyx5ZVmzWkczHLJv5KCeH+p2bnXp7rr0OXy/UJhpFqurvnXYrE/XqWYdL/zVx0xMTExMTEyuTl7nFTAxMTExMTE1N5H0TExMTExMLk8kPRMTExMTk8uT93pFYWR6EP6fnWyaHoQAAGD7kPQAALiMpAcAwGUkPQAALiPpAQBwGUkPAIDLSHoAAFxG0gMA4DKSHgAAl5H0AAC4jKQHAMBlJD0AAC4j6QEAcBlJDwCAy0h6AABcRtIDAOAykh4AAJeR9AAAuIykBwDAZSR96tWzx89edV1EXQ4HXmRw2HUpAIBO1Zz0/zVfts3zsOeFXjQN4nmHg2SOF3peGMXT+SjsjdSKjUsq80fn4flIWszzDKtKvHr26INHz06fPX52+uzRB4+K8t649YEnbVrfzThuD4UFzsNeOt+8IU+wXl6fj3odJP3hQN6vw9AbhOFh6PXCtG1GvXiZ6u2Z93M3bN/Tmk6aV2OTnI961db46tmjD2KPT6NZp48/SBW+5trco3iHPM/rZa9km/dIWKsjexSJflAlK7Vjj7LXXAPthFj9SW/cTDb/POyJcZhQ4yFaNifp9SVHvexNg2JQlAqZ6Jei+LWft/VBskfnoyzPBmmQJ7t8Pgp7vXiPzkfhYFDw5iM8HGz+mu8s6aX9Kkv6iu1pXLKoCnHXDwfpcf581KvpcBKttEojnz5OD7Wv0veSp4+Tl9ursveXyeaa3qPzUS95zY56hcloyx5lnNqjw4HXGwxKXni27FE3h6m7xomkPw97+XFeIelXO6cvSKa0kvOR9M4jCr9od0aD8DwMRyPz3glPUV/956NebzQaeJ4X/5e+zR6MknfF8qFM+xUS3j1H8+XDn/CVtmTuTI26XxskvfiTrSvpy4/5qyk/Tr169ig9pQqzY212zFWXMGttj5L15++WjXtU/HOyao8qvcW0Z49I+ja0nvRh0q8uHPdDpW82+VZ5730vPJfP/HQVz+krXqc31pkm0+EgDnjlvDYK/vNRODgMz0fhKHlQnPSZ3ug8exN9OPDiX/Te6Dxe0JTb6q+Q+N3ssfIuPcnf7HnpAsaZBul+xS1/GPZG8ZULcTL03ue3Z96S+QqOUIXVCx2ecrdnnvLjlHBwTbbw+FScLZx8bcMehWHZXlm1R8lvUmEoWbRHyXpKXnj27JHYe1/z+1WkGkn635KFpncASt5vck5fU9JXkncOqiSQMenj5wrn/aue03uDw/T3S0j6dEHll1/6Uvle+rT01zVZoXrhTHyjoc40lx6fxA8GwhuaFc/p9USv75y+8Ai1sk2SvtoF01hre1RyQh/auEdhyU5Zs0fZFtZO+i3bI0ETV20Q6eCcXjTwio74VXvvD4s+otVO0o/O4whPL8Prvffmj6rlbqilpE9WJKzH+Btc/df6MO7AGJ2Hg8GaSa+0Z96SBUUU9zoWdkzXfE5f0o/66tmjSkfdlvaoytHWrj0ybsDOPVLfbhe85bZkj/T947S+EZ0mvXDNvvNP5FVU/gmyaHPixxGSx40nvXrWUqX3PnpebzQSt2c8/Sk70RP3qxcOBuF5GB4O4ksV638ir+7r9MLVjlpUuMoofvYp77NRG1wxrXGPqp5U2bNH0tYKQsS+PSp74dm3R8mFyVrXiUjrSX9ouFgbKldhhb+yK7myK6S4+U/d2k366HH87uRQrSeNt2RdJUmv/OlJftLrb+/V9/6DQ2Wl8u+T/ltrvHZW8YKa0rfhlSS98a/s9Pas7a/sajuUKBsq6+9W+0zF7tXTx0UnWG3tkXbGaP0eiSstXacde5Sq8BbTjj0SXnbEfGO6+Ht61Ek/+V9rHfyOAYCjuEee7TZP+srd8gAACzWb9JzKN2+jpI964zifBwCHkfQAALiMpAcAwGUkPQAALiPpAQBwGUkPAIDLSHoAAFxG0gMA4DKSHgAAl5H0AAC4jKQHAMBlJD0AAC4j6QEAcBlJDwCAy0h6AABcRtIDAOAykh4AAJeR9AAAuIykBwDAZSQ9AAAuI+kBAHAZSQ8AgMtIegAAXEbSAwDgMpIeAACXkfQAALiMpAcAwGUkPQAALiPpAQBwGUkPAIDLSHoAAFxG0gMA4DKSHgAAl5H0AAC4jKQHauN53sXPjpSp66I2ou+O7XsE3EEkPVAbkh7AFiLpgdqQ9AC2EEmfevXs8bNXXRdRl8OBFxkcdl3KXSIm/V9+94P/8sz6XLz42dHFTz4e/z8fPyfpAWt1kfTnYc8LvWgaxPMOB8kcL/S8MIqn81HYG6nPNi6pzB+dh+cjaTHPM6wq8erZow8ePTt99vjZ6bNHHzwqynvj1geetGl9N+O4PRQWOA976XzzhjzBenl9Pup1kPSHA3m/DkNvEIaHodcL07YZ9eJlqrdn3s/dsH1PazppXnGTnD7+QPT4NJmXvC5ePXsUzTVIk/75weiD7z4VcvF81Kv2g4wX9Dyvl72WSvazZElxxYUFZNtOa03ftaS7Q9ID1mk96c/DnhiHCTUeomVzkl5fctTL3jQoBkWpkHn17JFwNM9l3Pog2aPzUZZngzTIk10+H4W9XrxH56NwMCh48xEeDjYP6c6SXtqvsqSv2J7GJYuqEHf9cJCm4fmoVyFwTx+LaX76+INHjx7FL44KSf+Tj8cffPsvs1yMNl/lx3E+6iWvmlGvWoJXW/Jw4PUGg5ICDBUm6f70v3ww+u8/IekBKzmR9OdhLz/OKyT9auf0BcmUVnI+kt55ROEX7c5oEJ6H4Whk3jvhKeox93zU641GA8/z4v/S09XBKDkXkw/42oFbOGeL5sshIXylLZk7U6Pu1wZJL/5k60r6asmoJ/2z02ePHp+GVZL+L7/7wfjgmXYGvOIbr8NBxb6cCuut+FajIOn1XgoA1uig9z7uVxeO+6HSN5t8q7z3vheey2d+uorn9BWv0xvrTJPpcBAHvHJeGwX/+SgcHIbno3CUPChO+kxvdJ6djB4OvPiw3Rudxwuacls9cIvfzR4rZ7tJ/mbPSxcwzjRI9ytu+cOwN4qvXIiTofc+vz3zlsxXkPSF1ccMSf/qVRT1pUkvnf6unfTV8rtS532yv5WSXrkikH0QT+ioqLoPALZDZ5/IU/J+k3P6mpK+krxzUCWBjEkfP1c471/1nN4bHKbHbSHp0wWVQ7n0pfK99Glp7CUrVC/Xim801Jnm0uOT+MFAeEOz4jm9nuj1ndOvm/RhePo4CvzSpM+67tdM+son9OULZy2xQgHpNQ7hI/fZO5iKdQHYEh1/9n7gFR3xq/beHxZ9RKudpB+dxxGeXobXe+/NH1XL3VBLSZ+sSFiPMQkrxKO4X+ejcHQeDgZrJr3SnnlLFhRR3Htftipz0oenjz94/KzppK/2SQJRwc9GfYNW9QN8Sa8PSQ84oNOkF67Zd/6JvIrKP0EWbU78OELyuPGkV8/tqvTeR8/rjUbi9owniZVPMw9DrxcOBuF5GB4O4ksV638ir+7r9MLVjgI5SR++evbo0aMae+9PHyef7xcWMpanLSntqxjeuUtqBeSvM75ERO894ITWk/7QcLE2zP8ru5Iru0KKm//Urd2kjx7H704O1XrSeEvWVZL0yh885Se9frKmnsklf+Y30JbM5ud9ds+81oLzQqVvwytJeuNf2entWdtf2ZWc0eb8lV36Oc2CxM39RJ5SktDU0Z98pKvTzsBzlyz4Izt1yZSW9OqSwuaTdfKJPMAB3DnHdnX8OV71nnkU8sx/ZVfg9HH++4ZtWJK/sgMcQNLbbvOkX+nTXyji5d45x6DiLRy6XZI75wAOIOltt1HSR13AnM/XxXPybrjPvi3GvO17BNxBjSd9qr19Ajri3ngw7u0RcAetm/QAAMAGJD0AAC4j6QEAcBlJDwCAy0h6AABcRtIDAOAykh4AAJeR9AAAuIykBwDAZSQ9AAAuI+kBAHAZSQ8AgMtIegAAXEbSAwDgMpIeAACXkfQAALiMpAcAwGUkPQAALiPpAQBwGUkPAIDLSHoAAFxG0gMA4DKSHgAAl5H0AAC4jKQHAMBl3ue2uQIAAJV5Xb/VWA1JDwDASkh6AABcRtIDAOAykh4AAJfpSX846I3O08deZHCYO0d4ovKt81HPsFiDSf/DH/6wtYYDAMAKUtKfj3qe53lJ0h8O4qBOI1ufIwV9sky0gnThFpL+8vLyT//0T7/2ta+13HwAAGw57Zz+fNSLk15I6nimPic/6fUFGkv68/Pz73znO1/72te+/vWvt9+CAABss2pJHz/W5yjPzHrvNzyhH/3H//x//bN/lU6j//ifC5L+u9/9bhTz3//+99tvQQAAtlmNSa+vpOCifrk/+MM/imL+D/7wj9KZxqS/uLj4sz/7s+9///vPnj1rvwUBANhm9fXe66sQ+vPXO7//gz/8IzHm85L+6urq9evXf/3Xf/38+fOWmw8AgC1XkPQrfiIvlS60cdLrCj57//bt27/9279ts+0AANh+ps/eZx3uK/2VXbqO9GQ/Wbi+j+bx9/QAAKyEO+cAAOAykh4AAJeR9AAAuIzx6QEAcJn3GgAAuIukBwDAZSQ9AAAuI+kBAHCZ9429bzk5dd2wAABsBcv+yq4ikh4AgIizSX93pq5fQgCAreZs0t/eDSQ9AKBYbtIH+0fG6X6gTm1GeEXf2PvWpeyzzz777LPPnso++uh7lzYj6QEApYqSfv8ojKf9MMiZbEn6/X21zi+++CLY3+8koetC0gMASq1wTq+fzd8Pju7fz0n6i28+8CTBZK3QvvjmgwffvFjxSd/Y+9YbWZr0b968OfoyPPoy/PjHr4Ng/43Nbm5uSHoAQLHcpBdPgp8/f54+/uyzz6IH8/l8f//o/v2gUkKvFdjZE1d8up5/0e789Kc/PTo6ev78+cc/fr2/fxQE+500el1IegBAqUpJn6Z7GIZPnz4Nw3A+n79582Z//+jBgwdFCZ19PQnWO6tfN+l/I9vfP9o/Onr69On+/tFHH30vmoJg/zcV/a+v9zzP+90/k77uff1/VX1+I0h6AECp3KT/6KPv/fSnP33+/Plnsigso4+zrZD06ZdZr3787XTGg29eSM/KMj4IHmTPkJbPT/p/kunX6T/+8ev45P7oaP/o6OXLl/9U4Pl/6PV6vd5/eJ5+6Xle+mVHlsslSQ8AKFaU9Olj8Zx+f/8oukh89GX40UffK0p6w2V6Icnjh8m5/sU3H3jBxJz04jm9vHx+0n8p298/+vzzz7/44osvvvji6Cj8+MevP/7xa3Gn7t8PXr58+WWeH3/Y63344Vd7H/74yy+//PLLH3y199Wv9pKvukLSAwBKrdZ7P5/Pnz59+ib5UFtJ0mcn3Uksq/EfZbh8gl+S9PLy+Un/a9n+/tHLly+lnomjo2g/w/1gf//o+fPnUdj/2uivPuz1PvyrH3y19+Ff/frXv/7BV3sf/uDDXvTFX33Yi3cn+jqboXw/eW62/1/9wa+lJ+jPyVlnhKQHAJTKTfpHjx4dHR1FuZhe4Y7+TS917+/vV+29j07F80/EJ4HnVTqnl5fPT/qXMr33Pk76MAzD8OXLl/eD4P79IAp7g//57/7Fv/h3/zP69+V3fid7HP+XLfPyO7/j/c53oi+93/mO+qW2TvEbVdcZm06nJD0AoFhR0mehuH8UfQTvzZs3H330vaMvw6gD/NGjR1U/e69Hfdpd76UX8B9880L44N4k8PSkV5fPTfoLWZT0UW/EF198cfRlkvT7QRgEYRgG+/f394/uB8GF0Y/ev3fv/R9d/Oj9e1/5kz/5iveVP4nn/Oj9e1IvRTbr3vs/Sp4pfpnOEBZPv1d1nTGSHgBQqlLSRz326bX59Dr3KkmfZvwkKPhEnvSJvQdCxkfPkq4AFH8i71yWJn0U80dfSpcn3rx58/Lly/2jo/v3g3Ojv3j/3r33/yL6/969r/xxMucv3r/nfeWPTc/44694nvCt5Ms//op37/2/ENaZrFmaU22dJD0AoFRR0qeftBd77KOP3D9K5CZ9p76x962/kUW5nsb80VGS9EEQBvc///zzYP9+lPR/Y/TD37937/d/GD3wfvvb2Zz06+RbP/z9e1666L3f/7b85Q+//dvJ4n/z7d/29DVUWecP46Kur69JegBAsaKkf/Dgwf37gfKv+CDSWn5X9429b72QSUl/FAZH99M/Lvjiiy9++tOffvbZZ9En8F8Y/fnv3bv3e39unrP/20k3e/T1n//ePfHrvC/Ns6qtM0LSAwBKOTuW3aks+nR9dP+caIqTPrgfBvefP39+P7gfJf1ph/7Tb3m/9Z+qL351dUXSAwCKOZv0x7Lo03a/+7u/ez8IoilK+vjOOcnlifv3g+O2fetfZ+f4//z//h8rPJOkBwCUcjbp/78yUa7rU+kTt8fbt29JegBAMWeT/id3AEkPACjlbNIzMTExMTExfWPvW24mPQAAiGRJ//i//79MTExMTExMjk1S0jf6nuLy8nKr1tM+eyu3ji1NbUudAKxG0rfH3sqtY0tT21InAKu1l/Rv3rzZqvW0z97KrWNLU9tSJwCrkfTtsbdy69jS1LbUCcBqnSb9xbjfH18Uz6m4Hk94WoWVdCKnckkyZG9l27qz3cpN0Engeab2WuuluDmSHkAL2kv6169fq7PWOrya1+MJB/BtDb9KLVBd9Nxt3dluGZo6DMMwnAReEASGBuso6fPqBIAatZf0v/nNb9RZax1e89YzDpIT4m0Nv0otsKpt3dluGZo6DMPwYtwPJuHEEPUdJX1OnQBQJynpb25uZ/NlE9Pt7bt//NUrdf1nI98fnUYP0v7raM4a6xHX5o9O58uDQdYrPngSzX848D3P8/y9p7vxgxczqYAHu2ddtIA0x1ykaXeEvWYqbuqobQdPZ/MXu37yU9ZfeMqc7Mfx8EB7kZzuPYgX3Huhf1mxzg5/+QHcEVLSL29up7NFE9Pt7bt/+OU/qus/3fP9vZPZi6Hv7RwsprPF9OCh5++drLmexcHA2znIvlQXON3zPX94upiKD+IC/OGptKr2WkC6TP/wILdI0+6k/zbzU7N0Mjf1bHGy60cvs5Nd3999MTW88LQ56U/B8CJ5suM9PIh/iA8P1C+r1tnhLz+AO6KlpH/37t0v/uGX5oQWs6ost4rWM1tMZ092xBWKOarMFx+ocZsc0FtrAeMc4wN9d0j6ik09ezEUf8zGF17BHMOLJF6hv/tCXH/yZdU6O/zlB3BHyEm/vLmezpuYbt+9+/wXv1TXf7Ln+3vH0b/inPXWM51fT+fHQ9/fGfj+3vH0yY7nD09MG1IenOz53uDTZna8euXqHPVBzu6UtdgdnHKbeudJ8uXZ0PeHB9oLT38pij+FnBfJpzueJ3xL+bK0zg5/+QHcEVuQ9NOzoe/tHMyvp/Pjoe9tlvTX0yc7nufF0ZgccA8GXkHSCwUUHNCbbAHTHEPSm3aHpK/W1MdD3x+eyV8+0V542ksxa17tRXKy58fvvZL3DeKXJ1Xr7PCXH8AdISX9YnlzdT1rYrq9fffzv/+Fuv7j3ff83ePoQdwn6sdz1lvP9ezqenY89D1/9zh6kPW27h6Lm1MeXB/sJMt947jdFpD6hL33dgZ5RZp3R953ppymPthRfrLHu+95g0/0F54yR2pe9UWS/kTeG57qX1ass8NffgB3hJT088Xy7dW0ien29t3Pfv755uuvaz3tT/ZWbt1kS1NHdXb4yw/gjpCTfr68fHvdxHR7e/t3P/v7zddf13ran+yt3LrJlqaO6uzwlx/AHSEl/Wy+eHN51cR0c3v7v//u55uvv671tD/ZW7l1ky1NHdXZ4S8/gDtCSvozAO3q8JcfwB2h3COvQcvlcqvW0z57K7eOLU29XC47/OUHcEdISf+6YZ7n1fIv4IYOf/MB3B1q0je3pdevX//qny43nzzPK9/YVuLI3hormtqKIgE4oNWk9zxv86S39/hob+XWsaKprSgSgAM4p28PR/bWWNHUVhQJwAGc07fH3sqtY0VTW1EkAAdUTPpJ4AWTzbZUdk7/3/6N928/3vyc/mLc748v1qhv7SdWXkPJkb1yARfjvngD3U1/MNVt3kRtyW1que1ymy7a04b3l6QH0I7SpE8PjTUkfc45/U/+/b+MNlEp6dfMy9Kj9tYmvTT/YtxXfhT6nAa0knw1Kkp6uTHNLZe3v7W2AEkPoB2c02/8xMpr2PycfhJ4xkUmQSsJ7FrSl7274pwegBPUpL+5uZ3Nl9r0dOA9PDDMX2Equ05fNekr5uUkkDtpDUftbJF0gXEg9esaV6IsI3UI15H0uZWLDzxpk/GM5M1Y/IYgWyyYxE8Pgr55Tn88GfezPTDXUNqGUm0lm2hU1aRP38JmZffHF9L+Sj9uzukBWEhN+uXN7XS20KYnO97DA8P8FabOzunNKSX23E6CJIayuMpbibqMsJ68M+7Eyuf0SuXRmbuwQTH6g3E6P0qvbLn40cW4n9SnzhEfFNRQ2oYX+Rst2EQDKie9tmPK/io/bpIegIVaTfo2z+nVU+3SbltxTpWV6If+unrv8zYaJX16IUUK0WCSnp+mQV9cqhdMjL0FBTWs0YYFm2jSauf0ykcco7d9pT/u5ooEgFppSb+8uZ7OtenJjjf41DB/hanZc3o1SITz67VTqngldSV99cqzJI/ySO6KTxaIr9lXKTU3hnNqcC/ps3N3+WMoVX7czRUJALVqNembPKdPwin+X/gIYdqvXNp7b0j6/JVovfdC77jZxpWXXR6I3gTIPfTZI7nbXzrvNyS9qYb1eu+3N+nTarWmIekBOERN+sXy5up6pk0HO97gE8P8FabGr9PH57pC0BX03gtPMHzYKnlctBK9o7vfX7P3vnrl4pXjnDXJQSas+GLc7/e1OeYH5hqk9xzqZxbVT+SVbaJRq/89fbojQo8ISQ/ACWrSzxfLt1fTJibukVdT5fpV5TR6Cv8YspWI3RJWvEisKBKAA7Skny8v3143MXHf+2aP7GLPvRFJv2WsKBKAA9Skn80Xby6vmpg4p7e3cutY0dRWFAnAAWrSnzWGc3qO7K2xoqmtKBKAA/R75DWFc3p7K7eOFU1tRZEAHKAmfdM8z6vlX8ABHf7mA7g7Wh2ffqvW0z57K7eOFU1tRZEAHEDSt8feyq1jRVNbUSQAB5D07bG3cutY0dRWFAnAASR9e+yt3DpWNLUVRQJwQHnSa/c7XVPBcW2lTRQdH4Xbx21WbCM6qVy5o157zdLpjXpymzr3brjaYnXf+3aFIgGgViVJr4+Ksra849qqm8g/PsojsG1f1rdeuX6X/LL75te12eZjslhR0htGuMlZrHiwvuaKBIBardB7v+FRrspxrcomqh3Et1HLleeNfBcPa9s0C5I+v0jO6QE4RL9zzu1svjRNL3Z9b/DE+K1KU4Xj2obn9IZhY7PrAvpga8lt4tVlLsb9eOj3mk9+W61cH2oveVo8Qx5uVlgsGcc1XpVhTn88GffTKoxlVBg8UKqtZBO1NbVaVTImUFaJOpbdONB2bY2CVioSAGqljU9/czudLfTpZNf3/L0T07cqTqXHtdLx3SOF61HGTJW/Iw8nbzhqp8f3NfOlRKuVR2fupiddjPvBOJ0fRZ1xMHt5oPt0jvggr4y1B7Mv3UQ1lZNeq1XZBU9uPpIegIUqJf3mMV+a9NXjtdLxMe25Vs6DiweY15epVauVR0mfDmMrhWgwSU9m06AvGIg9ekrBSPPGMkr7yQs2qj+oq6mN5/T6OMATxqcH4A4t6Zc319O5OB0Pfc/fO5ZnrjEVHNdWOouudnyMEkz+pJs5LwuXqVWrlWdJHoWX3BWfLBBfsy9N+qIYzinDiqTPzt3lKzWljVAHkh5AO8qS/mDgeYNPN475oqSfBCtdEa/wGf70zDg9pZUuR8vd2doyrSd9M5XnfSAvJQ5ob+xIl/8ioijpTWWs13vfatKnBWh7S9IDcIia9IvlzdX1LJ0+2ZG6Nd8bnorfXWnKO66Jn+eq8gmsSn+Xb/oQm7lXXF+mi3P6RioXLzPnbFROPXlb/b42x/zAXEZWTPpWIP8TeWWbqK2p5Y56oXHS2oRODpIegBPUpJ8vlm+vpk1MW3ePPOFctB1dVK5fgk5zqnAtjb3daYcVIWpFkQAcoCX9fHn59rqJaTuSXuxBaDvKtqhysefeiKRvnhVFAnCAmvSz+eLN5VUT03YkfZfsrdw6VjS1FUUCcICa9GeNIentrdw6VjS1FUUCcIB+j7ymkPT2Vm4dK5raiiIBOEBNegCt6fA3H8Ddwfj07bG3cutY0dRWFAnAASR9e+yt3DpWNLUVRQJwAEnfHnsrt44VTW1FkQAcQNK3x97KrWNFU1tRJAAHlCf9RByfewMFx7WVNpGzHu3u+fqwJV1r+siu3A+vvZ3fvtvs5DZ17t1wtcWavC9ySZEAUKuypM/ujb7pzWNzj2srbiJvPYZRyoKgheN1dVWP7OvEjH6P+7K73teilURcQ1HSG0a4yVmsePy95ooEgFpV773f9CBX4bhWaROVD+JbFj5NHtnzxq2LB6Vt2vY1drUXSX7lnNMDcIh+55zb2XxpmM5GvvfwwPitalP5ca1af3v+eoQDs2mgdPHG8dEI8OrAsA0zV34x7ovju3v98WTFssWR3+R748czDOPfCr3Xce+HeU5/PBn3s1vtK8XkJ2L+sHVlm2iwqUM92pNupKw8dSy7caDtb9NFAkCttPHpb26ns4Uynez6nuftHKjzV5qKj2vRkXaD6/TxSqTBTov7YLM3Fi2NapdXefo+QxqmvXrZ0Zm7Pn59GF6M+8FYWd44FL08TH06R3yQV8zaQ9GXbmIDlZNe2wFlvzy5TUl6ABaqlPTT2WI6e08JzAIAACAASURBVDH0Nwr7ar335ZFbtB4p4bWjsza+exyVbQ1fWxY/65YdJX36pRSiwoJp0BeMuR49pWCceKUYY/4VX97W926zoejXaurUJIj2V/woo9atYii70SIBoFZa0i9vrqdz43Q89P3hWd53S6cqx7UqB9LyDxNM5PCIVyr00KebmQReMGnpYnbpdYe1y86SPMopuSteWb406YtiWCvG9qRXu0m0+SQ9APuVJP3x0Pd2nlxP59fTs6Hv7RysGfMFSS/3Om92Th8dkPvJ0ViNTP2yfOk47XUqvu6QFbJy2aUfMxCXN3akyz+AoqTXeuXX7r3vPunTqrQmIOkBOERN+sXy5up6Jk6f7MR9mu8NT5VvrTRV+Xv6KkfRkuOjcNVZOTpLfbTC+XBbQV923WGTssUryibS8ukas4jta3PMD9Ri1PwTrijkfSKvbBO1WP3v6eXXIEkPwCFq0s8Xy7dX0yamzu6RV3R0busSfRiGq1a+ctn61eaLwuWrbMhWVoSoFUUCcICW9PPl5dvrJqZukj46VTPGXKs992G4UuU1ll26PEnfESuKBOAANeln88Wby6smJu57b2/l1rGiqa0oEoAD1KQ/awxJb2/l1rGiqa0oEoAD9HvkNYWkt7dy61jR1FYUCcABatIDaE2Hv/kA7g7Gp2+PvZVbx4qmtqJIAA4g6dtjb+XWsaKprSgSgANI+vbYW7l1rGhqK4oE4ACSvj32Vm4dK5raiiIBOKBq0m9+19jS41rFTZSsZxIU3SdmjbvE1Hdjma2qXLmjXnt3CmzlRj25TZ17N1xtsbrvfbtCkQBQq2pJfzHub3w7uZLjWuVNFK9nEnhBkD843RYnfYuV63fJL7tvfi1aic9I0SvZMMJNzmLFg/I1VyQA1KpK0l+M+/0g2PQQV3hcW2ETZesJJmH+OLTbm/TtVZ7Xd9LS6L1blPT5xXBOD8Ah+p1zbmfzpTQ9eegNnp7uPfD3XqjfWmUqOq5NgnSk0NKKi9YTxaVw/M6GVItOWZXv9McX+jLKuGsX435/PA7K+nsr2IrKxbHj5NFw4hnKGLnZYsn4rv0g6Jvn9MeTcT8bXMe8C4Yfc/7Ad2WbWLmp1a0nY/9kW1THspMakHN6ABbSxqe/uZ3OFsL0ZMd7eDBbnOz6/u4L+VurTfnHtfhou3nSx3FpXJU66LtpU8oo7OlQ5XpMrmUrKo/O3OUB2dPoD8bp/GhVpnHllYHu0zniA2OntznpxS70/MHsSzdRsakNW5drUkpVGpCkB2ChkqRPA765pF91gPL846P8aSv9zDU5dqvn5soyyddZoCmDlFdp162tPEr6dBhbKUSDSfq2Kw36ggHa0/cTeSPN67ugh2XxtXDlKZVfK6ud08vNH3cc6DtL0gOwk5b0y5vr6TyZzoa+dAj0h2fCd1eb8j8EoBxlSw6kRQfxLAWjQ7JwBpydpUmnqtJla/k4Pgk8T7mo0FDSt1l5luRRc8td8ckC8TX70qQvimHTLmxb0kttqy1G0gNwQnHSZ9Px0N8k5vOTPrPhOb3pGD4O9I7h7HRT7KaWl/GEPJk0nvTtVl76x4zigPbGjnThYrp43m9IetMurNd730jSpxvS9oqkB+AQNekXy5ur65k+HQ/994anxm9VnBpOei3ALsZ9LxgrHzuTL8hKXd5Cl0I6p598rq3JpG+98ouSP6mTCpLWGK2nr80xP1DLU8MyfSuQ/4m8sk2s2NRqF5LQCGkNQmcGSQ/ACWrSzxfLt1fTJibukbdNlRdcNBHOxY3Pqy/qmrNNTZ3LiiIBOEBL+vny8u11ExNJb0HlYs+9EUlfHyuKBOAANeln88Wby6smJpLe3sqtY0VTW1EkAAeoSX/WGJLe3sqtY0VTW1EkAAfo98hrCklvb+XWsaKprSgSgAPUpAfQmg5/8wHcHYxP3x57K7eOFU1tRZEAHEDSt8feyq1jRVNbUSQAB5D07bG3cutY0dRWFAnAASR9e+yt3DpWNLUVRQJwQGnSi4OMb3TPlPzj2mqbKDo+1lZsIzqvXLkxXsENcevfcLs/jtymzr0brrZY3fe+XaFIAKhVlaSvJxEKk36FTeSuZxKoNzLfsrDvtHL9Zvdlt7+va7PNR6auKOkNI9zkLFY8zl5zRQJArcqSvr5DW7WD79rrseA2rR1WnvfmIR6dtmlbmvT5hXFOD8Ah+p1zbmfzZTadjdIR6v29F9K3VpyqdKiuP5Zd/kFZ7BdXh0pLNqkukwwcW28vd2eVSyPeSs+PZygj3meLJWO6KsPYC3P648m4n/3sjPWYIjN//LqyTazf1IbWTvqTsq2rY9lJjck5PQALaePT39xOZ4tsOnjo+Xsns8V09mLoezsHC+m7q0xFfdfaaOgFyvNSHoBUW0YejNy4jNix3XSvRguVR2fupmdfjPvBWBnw3jgmvfwTSueID/LqWXtM+tJNrNrUhnbT6lPKVhqTpAdgobKkF6aTXd/ffVF/0guqHEirnhkbT2SNg45XXGZjnVUeJX36cQgpRINJemKbBn3BoOzRUwoGjDfWU9pnXrBR/cHaTW1YySSIdscT9ccTxqcH4A4t6Zc319O5cToe+v7wLO+7pVOzSa8/NZ4hXKE25lbVZWrQWeVZkkdBJnfFJwvE1+xLk74ohnPq2dqkz87d5b6k0h2vA0kPoB0lSX889L2dJ9fT+fX0yY7nD0/WjPmCpBcOs5U+dF7tE+zpQOvCB/uFq9ByL7a2TKtJ30LlpQ0rjktv7EgXLqaL5/2GpDfVs17vfeNJn25U20OSHoBD1KRfLG+urmfi9MlO3Kf53vBU+dZKU8FxLe/ytFG1v0pPOmANn0IzfK5NXablpG+hcvGSc8725QSUN9rva3PMD8z1SO850s8EeFLHgmGjzSS90E0v/2mj3KwkPQBXqEk/XyzfXk2bmLbxHnm13Sygkq4r1y9Hp5lVuLpa460dVoSoFUUCcICW9PPl5dvrJqatSfrObqS3pZWLPfdGJH0zrCgSgAPUpJ/NF28ur5qYtibpO2Nv5daxoqmtKBKAA9SkP2sMSW9v5daxoqmtKBKAA/R75DWFpLe3cutY0dRWFAnAAWrSA2hNh7/5AO4Oxqdvj72VW8eKpraiSAAOIOnbY2/l1rGiqa0oEoADSPr22Fu5daxoaiuKBOAAkr499lZuHSua2ooiATigQtJP6hmnPf+4ttoNYUqOj5OgaCWd3gSmtcqVm+G1dxvArbnHTm5T594NV1us7nvfrlAkANSqNOmz0VcqjT+TrzDpVwij4uPjJPCCIMitM28UtVYiqpXK9Rvcl93yvhYtNmMVRUlvGOEmZ7HiMfeaKxIAalWW9BvGu6DawXeD9cTrCibxeOyrbKv7pK+n8rwfV/56a2VZ0pe1Kuf0AJyg3znndjZfptPp3gNv8FScs/ZUpUN107HsorgUB1brj8fixQdpULV0sLVkvPaGU6rxysVh3+QLIvEMwyi4Qje2uEJtTn88GfezTYlXXLLyDNGYP2Zd2SYaaWq1wqQ/KatKHcsu56dQA5IeQDu08elvbqezRTqd7Pr+4KEfHeoGT8RvrTrlHtey89D83lRBwfExjsv0gCz2W0tRJJz6bkfvfT2VR2fu8mDrafQH43R+FG+mIeGVn0Q6R3xQcBHBdCmhfBz60k3U2NSGCuW6ld0x/xTqQdIDaEd50nv+3slsMZ29GPrezkEDSS+ociDNX4/8aau88cWVz2JtRdLXVHmU9OnHHqQQDSbpCWwa9AWDr0dPEd8pFHQb5CV98XVu5Sn6gw2sdk4vN3/cuZD3UyDpAdhGS/rlzfV0nk0HA394Fj0+Hvrp4zWmxpM+PS9O1zQx5qV0OrsVSV9X5VmSR4Eld8UnC8TX7EuTviiGc7oWrEt6qW21xUh6AE4oS/rpkx1v8Ol0fj09G/rezsGaMV+Q9MJhttLH/wrWox7Dg6AoV7LrxB0nfX2VlzagOBa9sSNduJgunvcbkl7rlV+7976zpBebUt5zkh6AQ9SkXyxvrq5n0vTpIO7U3DlQv7XKVHBcSz+1VeUomrMeLeSiLtn8I/XFuJ/108YlNPu3aG1ULl5aLt1Y2mudRWxfm2N+IHV4G5I+fSuQ/4m8sk1sYvW/p5dfgyQ9AIeoST9fLN9eTZuYuEdeW5Xrl53Fv8LLfxvQSsdGO6x4kVhRJAAHaEk/X16+vW5iIuk7rlzsuTci6dtlRZEAHKAm/Wy+eHN51cRE0ttbuXWsaGorigTgADXpzxpD0ttbuXWsaGorigTgAP0eeU0h6e2t3DpWNLUVRQJwgJr0ANrR4a89gDtFSvoO6wAAAE0g6QEAcBlJDwCAy0h6AABcRtIDAOAykh4AAJeR9AAAuIykBwDAZSQ9AAAuI+kBAHAZSQ8AgMtIegAAXEbSAwDgMpIeAACXkfQAALiMpAcAwGUkPQAALiPpAQBwGUkPAIDLSHoAAFxG0gMA4DKSHgAAl5H0AAC4jKQHAMBlJD0AAC4j6QEAcBlJDwCAy0h6AABcRtIDAOAykh4AAJeR9AAAuIykBwDAZSQ9AAAuI+kBAHAZSQ8AgMtIegAAXEbSAwDgMpIeAACXkfQAALiMpAcAwGUkPQAALiPpAQBwGUkPAIDLSHoAAFxG0gMA4DKSHgAAl5H0AAC4jKQHAMBlJD0AAC4j6QEAcBlJDwCAy0h6AABcRtIDAOAyKemZmJiYmJiYHJuypH8NAACcQ9IDAOAykh4AAJdxnZ6JiYmJicnlqb3P3l9eXm7Vetpnb+XWsaWpbakTgNVI+vbYW7l1bGlqW+oEYLX2kv7NmzdbtZ722Vu5dWxpalvqBGA1kr499lZuHVua2pY6AVit06S/GPf744viORXX4wlPq7CSTuRULgkmK650W3e2W7kJOgk8z9Rea70UN0fSA2hBe0n/+vVrddZah1fzejzhAL6t4VepBaqLnrutO9stQ1OHYRiGk8ALgsDQYB0lfV6dAFCj9pL+N7/5jTprrcNr3nrGQXJCvK3hV6kFVrWtO9stQ1OHYRhejPvBJJwYor6jpM+pEwDqJCX9zc3tbL5sYrq9ffePv3qlrv9s5Puj0+hB2n8dzVljPeLa/NHpfHkwyHrFB0+i+Q8Hvud5nr/3dDd+8GImFfBg96yLFpDmmIs07Y6w10zFTR217eDpbP5i109+yvoLT5mT/TgeHmgvktO9B/GCey/0LyvW2eEvP4A7Qkr65c3tdLZoYrq9ffcPv/xHdf2ne76/dzJ7MfS9nYPFdLaYHjz0/L2TNdezOBh4OwfZl+oCp3u+5w9PF1PxQVyAPzyVVtVeC0iX6R8e5BZp2p3032Z+apZO5qaeLU52/ehldrLr+7svpoYXnjYn/SkYXiRPdryHB/EP8eGB+mXVOjv85QdwR7SU9O/evfvFP/zSnNBiVpXlVtF6Zovp7MmOuEIxR5X54gM1bpMDemstYJxjfKDvDklfsalnL4bij9n4wiuYY3iRxCv0d1+I60++rFpnh7/8AO4IOemXN9fTeRPT7bt3n//il+r6T/Z8f+84+lecs956pvPr6fx46Ps7A9/fO54+2fH84YlpQ8qDkz3fG3zazI5Xr1ydoz7I2Z2yFruDU25T7zxJvjwb+v7wQHvh6S9F8aeQ8yL5dMfzhG8pX5bW2eEvP4A7YguSfno29L2dg/n1dH489L3Nkv56+mTH87w4GpMD7sHAK0h6oYCCA3qTLWCaY0h60+6Q9NWa+njo+8Mz+csn2gtPeylmzau9SE72/Pi9V/K+QfzypGqdHf7yA7gjpKRfLG+urmdNTLe3737+979Q13+8+56/exw9iPtE/XjOeuu5nl1dz46HvufvHkcPst7W3WNxc8qD64OdZLlvHLfbAlKfsPfeziCvSPPuyPvOlNPUBzvKT/Z49z1v8In+wlPmSM2rvkjSn8h7w1P9y4p1dvjLD+COkJJ+vli+vZo2Md3evvvZzz/ffP11raf9yd7KrZtsaeqozg5/+QHcEXLSz5eXb6+bmG5vb//uZ3+/+frrWk/7k72VWzfZ0tRRnR3+8gO4I6Skn80Xby6vmphubm//99/9fPP117We9id7K7dusqWpozo7/OUHcEdISX8GoF0d/vIDuCOUe+Q1aLlcbtV62mdv5daxpamXy2WHv/wA7ggp6V83zPO8Wv4F3NDhbz6Au0NN+ua29Pr161/90+Xmk+d55RvbShzZW2NFU1tRJAAHtJr0nudtnvT2Hh/trdw6VjS1FUUCcADn9O3hyN4aK5raiiIBOIBz+vbYW7l1rGhqK4oE4ICKST8JvGCy2ZbKzun/27/x/u3Hm5/TX4z7/fHFGvWt/cTKayg5slcu4GLcF2+gu+kPprrNm6gtuU0tt11u00V72vD+kvQA2lGa9OmhsYakzzmn/8m//5fRJiol/Zp5WXrU3tqkl+ZfjPvKj0Kf04BWkq9GRUkvN6a55fL2t9YWIOkBtINz+o2fWHkNm5/TTwLPuMgkaCWBXUv6sndXnNMDcIKa9Dc3t7P5UpueDryHB4b5K0xl1+mrJn3FvJwEciet4aidLZIuMA6kfl3jSpRlpA7hOpI+t3LxgSdtMp6RvBmL3xBkiwWT+OlB0DfP6Y8n4362B+YaSttQqq1kE42qmvTpW9is7P74Qtpf6cfNOT0AC6lJv7y5nc4W2vRkx3t4YJi/wtTZOb05pcSe20mQxFAWV3krUZcR1pN3xp1Y+ZxeqTw6cxc2KEZ/ME7nR+mVLRc/uhj3k/rUOeKDghpK2/Aif6MFm2hA5aTXdkzZX+XHTdIDsFCrSd/mOb16ql3abSvOqbIS/dBfV+993kajpE8vpEghGkzS89M06ItL9YKJsbegoIY12rBgE01a7Zxe+Yhj9Lav9MfdXJEAUCst6Zc319O5Nj3Z8QafGuavMDV7Tq8GiXB+vXZKFa+krqSvXnmW5FEeyV3xyQLxNfsqpebGcE4N7iV9du4ufwylyo+7uSIBoFatJn2T5/RJOMX/Cx8hTPuVS3vvDUmfvxKt917oHTfbuPKyywPRmwC5hz57JHf7S+f9hqQ31bBe7/32Jn1ardY0JD0Ah6hJv1jeXF3PtOlgxxt8Ypi/wtT4dfr4XFcIuoLee+EJhg9bJY+LVqJ3dPf7a/beV69cvHKcsyY5yIQVX4z7/b42x/zAXIP0nkP9zKL6ibyyTTRq9b+nT3dE6BEh6QE4QU36+WL59mraxMQ98mqqXL+qnEZP4R9DthKxW8KKF4kVRQJwgJb08+Xl2+smJu573+yRXey5NyLpt4wVRQJwgJr0s/nizeVVExPn9PZWbh0rmtqKIgE4QE36s8ZwTs+RvTVWNLUVRQJwgH6PvKZwTm9v5daxoqmtKBKAA9Skb5rnebX8Czigw998AHdHq+PTb9V62mdv5daxoqmtKBKAA0j69thbuXWsaGorigTgAJK+PfZWbh0rmtqKIgE4gKRvj72VW8eKpraiSAAOKE967X6nayo4rq20iaLjo3D7uM2KbUQnlSt31GuvWTq9UU9uU+feDVdbrO57365QJADUqiTp9VFR1pZ3XFt1E/nHR3kEtu3L+tYr1++SX3bf/Lo223xMFitKesMINzmLFQ/W11yRAFCrFXrvNzzKVTmuVdlEtYP4Nmq58ryR7+JhbZtmQdLnF8k5PQCH6HfOuZ3Nl6bpxa7vDZ4Yv1VpqnBc2/Cc3jBsbHZdQB9sLblNvLrMxbgfD/1e88lvq5XrQ+0lT4tnyMPNCosl47jGqzLM6Y8n435ahbGMCoMHSrWVbKK2plarSsYEyipRx7IbB9qurVHQSkUCQK208elvbqezhT6d7Pqev3di+lbFqfS4Vjq+e6RwPcqYqfJ35OHkDUft9Pi+Zr6UaLXy6Mzd9KSLcT8Yp/OjqDMOZi8PdJ/OER/klbH2YPalm6imctJrtSq74MnNR9IDsFClpN885kuTvnq8Vjo+pj3Xynlw8QDz+jK1arXyKOnTYWylEA0m6clsGvQFA7FHTykYad5YRmk/ecFG9Qd1NbXxnF4fB3jC+PQA3KEl/fLmejoXp+Oh7/l7x/LMNaaC49pKZ9HVjo9RgsmfdDPnZeEytWq18izJo/CSu+KTBeJr9qVJXxTDOWVYkfTZubt8paa0EepA0gNoR1nSHww8b/DpxjFflPSTYKUr4hU+w5+eGaentNLlaLk7W1um9aRvpvK8D+SlxAHtjR3p8l9EFCW9qYz1eu9bTfq0AG1vSXoADlGTfrG8ubqepdMnO1K35nvDU/G7K015xzXx81xVPoFV6e/yTR9iM/eK68t0cU7fSOXiZeacjcqpJ2+r39fmmB+Yy8iKSd8K5H8ir2wTtTW13FEvNE5am9DJQdIDcIKa9PPF8u3VtIlp6+6RJ5yLtqOLyvVL0GlOFa6lsbc77bAiRK0oEoADtKSfLy/fXjcxbUfSiz0IbUfZFlUu9twbkfTNs6JIAA5Qk342X7y5vGpi2o6k75K9lVvHiqa2okgADlCT/qwxJL29lVvHiqa2okgADtDvkdcUkt7eyq1jRVNbUSQAB6hJD6A1Hf7mA7g7GJ++PfZWbh0rmtqKIgE4gKRvj72VW8eKpraiSAAOIOnbY2/l1rGiqa0oEoADSPr22Fu5daxoaiuKBOCA8qSfiONzb6DguLbSJnLWo909Xx+2pGtNH9mV++G1t/Pbd5ud3KbOvRuutliT90UuKRIAalWW9Nm90Te9eWzucW3FTeStxzBKWRC0cLyuruqRfZ2Y0e9xX3bX+1q0kohrKEp6wwg3OYsVj7/XXJEAUKvqvfebHuQqHNcqbaLyQXzLwqfJI3veuHXxoLRN277GrvYiya+cc3oADtHvnHM7my8N09nI9x4eGL9VbSo/rlXrb89fj3BgNg2ULt44PhoBXh0YtmHmyi/GfXF8d68/nqxYtjjym3xv/HiGYfxbofc67v0wz+mPJ+N+dqt9pZj8RMwftq5sEw02dahHe9KNlJWnjmU3DrT9bbpIAKiVNj79ze10tlCmk13f87ydA3X+SlPxcS060m5wnT5eiTTYaXEfbPbGoqVR7fIqT99nSMO0Vy87OnPXx68Pw4txPxgryxuHopeHqU/niA/yill7KPrSTWygctJrO6Dslye3KUkPwEKVkn46W0xnL4b+RmFfrfe+PHKL1iMlvHZ01sZ3j6OyreFry+Jn3bKjpE+/lEJUWDAN+oIx16OnFIwTrxRjzL/iy9v63m02FP1aTZ2aBNH+ih9l1LpVDGU3WiQA1EpL+uXN9XRunI6Hvj88y/tu6VTluFblQFr+YYKJHB7xSoUe+nQzk8ALJi1dzC697rB22VmSRzkld8Ury5cmfVEMa8XYnvRqN4k2n6QHYL+SpD8e+t7Ok+vp/Hp6NvS9nYM1Y74g6eVe583O6aMDcj85GquRqV+WLx2nvU7F1x2yQlYuu/RjBuLyxo50+QdQlPRar/zavffdJ31aldYEJD0Ah6hJv1jeXF3PxOmTnbhP873hqfKtlaYqf09f5ShacnwUrjorR2epj1Y4H24r6MuuO2xStnhF2URaPl1jFrF9bY75gVqMmn/CFYW8T+SVbaIWq/89vfwaJOkBOERN+vli+fZq2sTU2T3yio7ObV2iD8Nw1cpXLlu/2nxRuHyVDdnKihC1okgADtCSfr68fHvdxNRN0kenasaYa7XnPgxXqrzGskuXJ+k7YkWRABygJv1svnhzedXExH3v7a3cOlY0tRVFAnCAmvRnjSHp7a3cOlY0tRVFAnCAfo+8ppD09lZuHSua2ooiAThATXoArenwNx/A3cH49O2xt3LrWNHUVhQJwAEkfXvsrdw6VjS1FUUCcABJ3x57K7eOFU1tRZEAHEDSt8feyq1jRVNbUSQAB1RN+s3vGlt6XKu4iZL1TIKi+8SscZeY+m4ss1WVK3fUa+9Oga3cqCe3qXPvhqstVve9b1coEgBqVS3pL8b9jW8nV3Jcq7yJ4vVMAi8I8gen2+Kkb7Fy/S75ZffNr0Ur8RkpeiUbRrjJWax4UL7migSAWlVJ+otxvx8Emx7iCo9rK2yibD3BJMwfh3Z7k769yvP6TloavXeLkj6/GM7pAThEv3PO7Wy+lKYnD73B09O9B/7eC/Vbq0xFx7VJkI4UWlpx0XqiuBSO39mQatEpq/Kd/vhCX0YZd+1i3O+Px0FZf28FW1G5OHacPBpOPEMZIzdbLBnftR8EffOc/ngy7meD65h3wfBjzh/4rmwTKze1uvVk7J9si+pYdlIDck4PwELa+PQ3t9PZQpie7HgPD2aLk13f330hf2u1Kf+4Fh9tN0/6OC6Nq1IHfTdtShmFPR2qXI/JtWxF5dGZuzwgexr9wTidH63KNK68MtB9Okd8YOz0Nie92IWeP5h96SYqNrVh63JNSqlKA5L0ACxUkvRpwDeX9KsOUJ5/fJQ/baWfuSbHbvXcXFkm+ToLNGWQ8irturWVR0mfDmMrhWgwSd92pUFfMEB7+n4ib6R5fRf0sCy+Fq48pfJrZbVzern5444DfWdJegB20pJ+eXM9nSfT2dCXDoH+8Ez47mpT/ocAlKNsyYG06CCepWB0SBbOgLOzNOlUVbpsLR/HJ4HnKRcVGkr6NivPkjxqbrkrPlkgvmZfmvRFMWzahW1LeqlttcVIegBOKE76bDoe+pvEfH7SZzY8pzcdw8eB3jGcnW6K3dTyMp6QJ5PGk77dykv/mFEc0N7YkS5cTBfP+w1Jb9qF9XrvG0n6dEPaXpH0AByiJv1ieXN1PdOn46H/3vDU+K2KU8NJrwXYxbjvBWPlY2fyBVmpy1voUkjn9JPPtTWZ9K1XflHyJ3VSQdIao/X0tTnmB2p5alimbwXyP5FXtokVm1rtQhIaIa1B6Mwg6QE4QU36+WL59mraxMQ98rap8oKLJsK5uPF59UVdc7apqXNZUSQAB2hJP19evr1uYiLpLahc7Lk3wJ+IVgAAB5lJREFUIunrY0WRABygJv1svnhzedXERNLbW7l1rGhqK4oE4AA16c8aQ9LbW7l1rGhqK4oE4AD9HnlNIentrdw6VjS1FUUCcICa9ABa0+FvPoC7g/Hp22Nv5daxoqmtKBKAA0j69thbuXWsaGorigTgAJK+PfZWbh0rmtqKIgE4gKRvj72VW8eKpraiSAAOKE16cZDxje6Zkn9cW20TRcfH2optROeVKzfGK7ghbv0bbvfHkdvUuXfD1Rar+963KxQJALWqkvT1JEJh0q+widz1TAL1RuZbFvadVq7f7L7s9vd1bbb5yNQVJb1hhJucxYrH2WuuSACoVVnS13doq3bwXXs9FtymtcPK8948xKPTNm1Lkz6/MM7pAThEv3PO7Wy+zKazUTpCvb/3QvrWilOVDtX1x7LLPyiL/eLqUGnJJtVlkoFj6+3l7qxyacRb6fnxDGXE+2yxZExXZRh7YU5/PBn3s5+dsR5TZOaPX1e2ifWb2tDaSX9StnV1LDupMTmnB2AhbXz6m9vpbJFNBw89f+9ktpjOXgx9b+dgIX13lamo71obDb1AeV7KA5Bqy8iDkRuXETu2m+7VaKHy6Mzd9OyLcT8YKwPeG8ekl39C6RzxQV49a49JX7qJVZva0G5afUrZSmOS9AAsVJb0wnSy6/u7L+pPekGVA2nVM2Pjiaxx0PGKy2yss8qjpE8/DiGFaDBJT2zToC8YlD16SsGA8cZ6SvvMCzaqP1i7qQ0rmQTR7nii/njC+PQA3KEl/fLmejo3TsdD3x+e5X23dGo26fWnxjOEK9TG3Kq6TA06qzxL8ijI5K74ZIH4mn1p0hfFcE49W5v02bm73JdUuuN1IOkBtKMk6Y+Hvrfz5Ho6v54+2fH84cmaMV+Q9MJhttKHzqt9gj0daF34YL9wFVruxdaWaTXpW6i8tGHFcemNHenCxXTxvN+Q9KZ61uu9bzzp041qe0jSA3CImvSL5c3V9UycPtmJ+zTfG54q31ppKjiu5V2eNqr2V+lJB6zhU2iGz7Wpy7Sc9C1ULl5yztm+nIDyRvt9bY75gbke6T1H+pkAT+pYMGy0maQXuunlP22Um5WkB+AKNenni+Xbq2kT0zbeI6+2mwVU0nXl+uXoNLMKV1drvLXDihC1okgADtCSfr68fHvdxLQ1Sd/ZjfS2tHKx596IpG+GFUUCcICa9LP54s3lVRPT1iR9Z+yt3DpWNLUVRQJwgJr0Z40h6e2t3DpWNLUVRQJwgH6PvKaQ9PZWbh0rmtqKIgE4QE16AK3p8DcfwN3B+PTtsbdy61jR1FYUCcABJH177K3cOlY0tRVFAnAASd8eeyu3jhVNbUWRABxA0rfH3sqtY0VTW1EkAAdUSPpJPeO05x/XVrshTMnxcRIUraTTm8C0VrlyM7z2bgO4NffYyW3q3LvhaovVfe/bFYoEgFqVJn02+kql8WfyFSb9CmFUfHycBF4QBLl15o2i1kpEtVK5foP7slve16LFZqyiKOkNI9zkLFY85l5zRQJArcqSfsN4F1Q7+G6wnnhdwSQej32VbXWf9PVUnvfjyl9vrSxL+rJW5ZwegBP0O+fczubLdDrde+ANnopz1p6qdKhuOpZdFJfiwGr98Vi8+CANqpYOtpaM195wSjVeuTjsm3xBJJ5hGAVX6MYWV6jN6Y8n4362KfGKS1aeIRrzx6wr20QjTa1WmPQnZVWpY9nl/BRqQNIDaIc2Pv3N7XS2SKeTXd8fPPSjQ93gifitVafc41p2HprfmyooOD7GcZkekMV+aymKhFPf7ei9r6fy6MxdHmw9jf5gnM6P4s00JLzyk0jniA8KLiKYLiWUj0Nfuokam9pQoVy3sjvmn0I9SHoA7ShPes/fO5ktprMXQ9/bOWgg6QVVDqT565E/bZU3vrjyWaytSPqaKo+SPv3YgxSiwSQ9gU2DvmDw9egp4juFgm6DvKQvvs6tPEV/sIHVzunl5o87F/J+CiQ9ANtoSb+8uZ7Os+lg4A/PosfHQz99vMbUeNKn58XpmibGvJROZ7ci6euqPEvyKLDkrvhkgfiafWnSF8VwTteCdUkvta22GEkPwAllST99suMNPp3Or6dnQ9/bOVgz5guSXjjMVvr4X8F61GN4EBTlSnaduOOkr6/y0gYUx6I3dqQLF9PF835D0mu98mv33neW9GJTyntO0gNwiJr0i+XN1fVMmj4dxJ2aOwfqt1aZCo5r6ae2qhxFc9ajhVzUJZt/pL4Y97N+2riEZv8WrY3KxUvLpRtLe62ziO1rc8wPpA5vQ9KnbwXyP5FXtolNrP739PJrkKQH4BA16eeL5duraRMT98hrq3L9srP4V3j5bwNa6dhohxUvEiuKBOAALenny8u3101MJH3HlYs990YkfbusKBKAA9Skn80Xby6vmphIensrt44VTW1FkQAcoCb9WWNIensrt44VTW1FkQAcoN8jrykkvb2VW8eKpraiSAAOUJMeQDs6/LUHcKdISd9hHQAAoAkkPQAALiPpAQBwGUkPAIDLSHoAAFxG0gMA4DKSHgAAl5H0AAC4jKQHAMBlJD0AAC4j6QEAcBlJDwCAy0h6AABc9v8DO+Stlk42VWQAAAAASUVORK5CYII=)
To achieve this in LINQ , we heve below two mechanism.
- Using Contain function
- Using JOIN
1.) Contain keyword on Array
Lets take an array EmployesID where we store our employee ID and check column emp.ID IN EmployesID array as below :
var EmployesID = new[] { 1,2,3,4,5 };
(from emp in dbContext.Employes
join EmpAdd in dbContext.EmpAddress on emp.Id equals EmpAdd.EmployeeId
where EmployesID.Contains(emp.ID)
select emp.Name);
2.) JOIN on Array
Here we join our array with ID as below :
var EmployesID = new[] { 1,2,3,4,5 };
(from emp in dbContext.Employes
join abc in EmployesID on emp.ID equals abc
select emp.Name);
Apply Contain keyword on collection can make impact on performance so here we recommend to use JOIN on array.
0 Comment(s)