hosseines
سه شنبه 21 بهمن 1393, 00:30 صبح
سلام خدمت دوستان
دو تا table بنام های Table_Amar و Table_Morekhsi بصورت تصویر زیر دارم.
می خوام کوئری بنویسم که وقتی تاریخ (مثلا 1393/11/20) را بعنوان شرط قرار می دهم بیاد افرادی را که در این تاریخ در Table_Morekhsi در مرخصی هستند را در Table_Amarدر فیلد Hozor مقدار False و فیلد DateHozor را مقدار تاریخ حضور قرار دهد.
کد رو بصورت زیر نوشتم ولی مشکل اینجاست که میاد رکورد اول را که در Table_Morekhsi هست را در Table_Amar را برابر false قرار میده در صورتی که شرط برقرار نمی باشد.
update Table_Amar Set Hozor='False' ,
DateHozor=(select Table_Morekhasi.Tadate from Table_Morekhasi
where Table_Morekhasi.Code_T=Table_Amar.id and '1393/11/20' between Azdate and Tadate)
where exists(select Table_Morekhasi.Code_T from Table_Morekhasi where Table_Morekhasi.Code_T=Table_Amar.id)
http://barnamenevis.org/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAWcAAAFBCAIAAAA kL/nxAAAd10lEQVR4nO2dTbazKhOFHZUNR2PjLNf6RpKuQ0g/fYeRCdj8JuAMvA3/CqxCSECKvPtp3PseYmBbwhbwWKeaAQAghCq3AABAYcA1AABhwD UAAGHANQAAYcA1AABhwDUAAGHANQAAYcA1AABhwDUAAGHANQAA YcA1AABhwDUAAGGIrtE3FU83iJWNfVM1/ehd7s3YN1X1XRUAgEh4zDX8x3wq1xj7puq6zulYAICbKME1hq6 qumHsG9gGAAr41DVGYwWzfrwc2XdmqVUD/aaXCQzdUpVpG0udw1HZfohdtSi169dP4EUABPCZawydNX6Xn4z tBzLIjxqMke83BdlMg/nyYUyrMxg/Lkc6pcIuAAjnI9cYx5E9wFpEGOVNP1pDeD7/zEAPofUzbbFN 0kFAHjzxb7G0NkT/7FvWFPYajDXCvY6hsX0FXb wom0fuSl4pkMAJ/w QrFXA94u0bYUDWGu7Fl4esaDqlwDQA 4SPXGDqjYN95kIausUIJGKvMMmIv8nQNT6kAAG8 dQ12H9JzN3Sv7MJE2L2HrdDfNUSpcA0APuHDfQ2ycmj60VyJ7E 9eraekzJNX57gVNixX4xl89zVcUuEaAISD91AAAGHANQAAYShw DfZ57PUzWQBAHhS4BgCgKOAaAIAw4BoAgDDgGgCAMOAaAIAw4B oAgDDgGgCAMOAaAIAw4BoAgDCqeZ6rqpoAAMAPuAYAIIxqnucn AAB4s7rG/wAAwI/DNZJun/z9/X1Zw/P5jKIkKapEqhKTi fzmXs6/4MYrpGumb /vy9rWMZAFDHpUCVSlZhcwDVSANeIiSqRqsTkAq6RArhGTFSJVC UmF3CNFMA1YqJKpCoxuYBrpOBu13i1Zpa/9nU69tVWVVU/rNJ9DCw11I/3NE3vR73Wczo C8dA3c6zfZn/ziLmCFMaIQpOVgKukYI8c433o16GvcCrlV1j biut275ftQ6LGMyRb4f9TFyXu39w8iYa1ABr9ZnUFP5l2Q/WQm4RgrUuAa5H7ava9d4PLauSV2DzGTW pdq67rdKjZuhPQmHMN6PF2DtHqU2hMCooc9fimsH /ti/ZIFV2Dxv8cMUaKoJIozH6yEnCNFChxjVd7dNqLFcq0uMZ7/a/pGi/az9ae9X7Ux S5fZEuTlW8H/X3xmG5hjku3ruwo9VXuzd6DLy3cYh0/PrjHqtXa40kh2scP7IRW39kRqYUsewnKwHXSIEO11gNwPjYquH sGuth9GCz8x79cutqS9HaZU931O8X4465xjH3MRuxTt0aRRfH2 18WxYiuwUZsmibWNeSIZT9ZCbhGCkp2jaWbPfaD6YTFvJuxrsH tnnzJt65hjaLL4z91jS3 QsSmaeLnGmLEsp sBFwjBTpcw zUr9ZrhbIfux58mnRcuYY5aGJw7RrmJN8Yh8YoOsrF46ePXYME go2Y1S7ZPZUilv1kJeAaKVDz5JV 0LbnrQ3ryeuxeDZXy/vKum3rqqrax1bUvjaHWXfUtq2NJCuUN2l2V2xs0DoDUNHT54 /foQtP3k9DmYiZpg3U/c5YhpO1nFFfA8F3uC3vGKiSqQqMbmAa6QArhETVSJVickFXCMF cI2YqBKpSkwu4BopgGvERJVIVWJyAddIAVwjJqpEqhKTC7hGCu 5zDb MhC7mElKcqhKpSkwu0vXqf5bDNZJeuT8AwK9wU97Q75mmKbeEa 1SJVCUmFwhCCm5aoTy/znxbxOVXJVKVmFwgCCmAa8RElUhVYnKBIKQArhETVSJVickFgp ACuEZMVIlUJSYXCEIK4BoxUSVSlZhcIAgpcLkGzesb3TWGrqqq qulHT6Hk8i9frZbv02PGvtmKmWqHLqC5z6B9dNNC6AbHd93ivx FDQ723UjX9HsemH2k5DbAhWipXDFwjBaJrvJeEcB8lNbh0jbFv qm6Yh 4j19iqaHq2grFvUruDhCWyb8jQGo2fJCKKp2KGrmn25se 2dzWDODQEReWLk7IRcsPXCMFVyuUNK6x8oVrrGOQq E88KLfxj1FLhptPcZU6Vr8TKctTbMPeDJtsOdcZzFD1/R9t84P4BrgO0p1je3GbXT0Bel2fcMc5CSSc4dhGMgB1vyDtby9 ZOgOg6AHjn1zNg7bNcYt3nAN8B1lusbQ7aON/HNFk2twc43R2PHwEE 3E8gq42rX5Owaq1/ANcB3FOkaxq7cabxocw0TY0/2vNdxIXLotjkFM8lyiNkjPfZN1wuuQdzE ojqlMp1AtdIQYmuYQ8Yq uqdg06Mse 8ZhrGAXmJMt9OqxrrJa7aRjJGmk010twDSAhuoaYDzaGa9iTha vb5rxf/tHaK6BPD 1atyEplcdn4p 8SguUpuuaTY0o0lyKGModH1ExNEbrz8ac4nQVzlqW2qVyxcA1U oDf8oqJKpGqxOQCQUgBXCMmqkSqEpMLBCEFcI2YqBKpSkwuEIQ UwDViokqkKjG5QBBSANeIiSqRqsTkAkFIwU15Q Ea96NKTC4QhBTclzc03UQGAAepO/Y/CFYoMVElUpWYXCAIKYBrxESVSFVicoEgpACuERNVIlWJyQWCkA K4RkxUiVQlJhcIQgrgGjFRJTKXmFhvCUapR9UV RlcrvGo1zeUvn/t9ewafMYamePyb 9Q0feplLxDRfuonryhC1KiViNj6On4s2zpePI94wtSu1eJY 16pHaPci68cI0UuN553czi1VZV 4rpGuQt76HzG/P08hsvaJ/T8uTD6qN68oZKiVppcjCjafJeLH0lXzxe0C 1e5k41qrHU c5wHCNFHitUN6POq5rUDxzNHi5hpySk0 9KZVz9Sz3tK4TbsEnkbOmvKF70w5Lok2bF4XPACSkHeMuZnBeM NetwEyJaGYVOn0JrpECH9d4td8l13C6xnVOqgXLNejEn9x5 JScUupNqdxRz24W7PA uQbnDjnyhm5Ns6N0szFaA7mHn5IHcccL4p3tiuVCPUy7jlxkC3 CNFFy5xvtRf708EV2DS2YlMclzDXP0sNsIXOpNR7lQj9guJ3LW lDfUoZk2Yy8utlHKTgdPycTkCUKYa1ysOc0VE1wjAy7XeD/qSH9EiXGNsW CNv48XOMiJed PL NR1NyCvV85hpMM7fnDXVotj7 uNylPMQ1PHZ2jnYNg8EK5S6cGQC/XphIrmEsB/y4dg05JaeUepMvl uJ4BqZ8oZKmukSSdqXpiNTPt45QQhwDb4esd2x78jyDbuh9yC4 xnt/6roSczf0NLsO2g3dv02fvC6dT0jJKebXlMrZehztnkXOmvKGMr Ufli38 UtpSSccL00QpHalcnmiIf6ZziMIePJ6F/gtr5ioEnmjmFh/Qjf n JVdUV BrhGTFSJVCUmFwhCCuAaMVElUpWYXCAIKYBrxESVSFVicoEgpA CuERNVIlWJyQWCkALkDY2JKpGqxOQCQUgB8oaCHyd1x/4HwQolJqpEqhKTCwQhBXCNmKgSqUpMLhCEFMA1YqJKpCoxuUAQ UgDXiIkqkarE5AJBSAFcIyaqROYSg7yhP8/lm/JVVUV4 VV4U555GUniuPzWm0 B784mhfZR5A11txuaN5RNcWQF fItZBAFrzfl34/6yzQbjjflPW8p9PJb6a0iv/D0BVYfRd7QiHlD2USzNKY 2dVAFHzzhsZ1DcqXrmGnzRHe4 anJ84Unh/AugbyhkbPG8p xhbDNVLgdo1Xm2yF4kg/ySK5Bs3XIqXSPPrZUnokuXGl8PyAk2tw7oC8oVflzhuJkFhM8B K4Rgq85hrkrxxEdI0VzyWG5RrM7foylaZlGaevJHAN5A11thua N1RONCtNQOAaKfB8hvJtmnLnMxSvNOUTO9cwFrnOes6W4ZlnNA TWNUyQN/SiXKrHnWhWunpwjRSIrvGoj6x/3/8ZJcs1fNJVWvCuse rbVXx3cqwjK2vX6Xw/IBr10De0Ityvp6LRLOy5cM1UuCYa2ybGkn2NcQ0kBLT cnrscI3/32atDuyVO5FNM/ox0z8k1fkDbW/EpY39CrRrGOeCNdIAX7LKyaqRN4oBnlD/y3gGjFRJVKVmFwgCCmAa8RElUhVYnKBIKQArhETVSJVickFgpA CuEZMVIlUJSYXCEIKkDc0JqpEqhKTCwQhBcgbCn6c1B37HwQrl JioEqlKTC4QhBTANWKiSqQqMblAEFIA14iJKpGqxOQCQUgBXCM mqkSqEpMLBCEFcI2YqBKpSkwuEIQUXLrGq62 feFVdo2h835jbL/8NN9kaPLR9dvJUo1eiiRv3o2GeON1LiONluP9tILE5AKukYIL1 3jUVft41Glco2 qjk/4wkAv/9A1zf41 u65F17pPD7DR6T5drghJjhRXjlicgHXSIHLNdYUXu8krrG 3uidDMcaA32/5WGgriGl5CSvWncDGRtC6s2llNyBfe rPiJzuUZeMbmAa6RAdI33npYngWscqXQ do1x676Ga7ApOe0k216pN7dp/fJvT9vwEZnNNbKKyQVcIwXOv2xAiP XDQiheUON3n/KjmWvvK1uvh/vTr350eDwEZnRNTKKyQVcIwUez1DSrFBWvphrrN/u9zEgpOSUXMO9wRHLNWyRZsXmpgz9iAZGKi9ITC7gGiko2zWMF YeYktNIRUkzULpSR8VzDWtZRBOd0n/Pt7hGLjG5gGuk4MI19nVKir9sQJ/8XQqdzOeIx7fsv9yxfmjkATWyYHbm1sZ5hWIntfQfGD4ijQa4f VyjXam8NDG5gGukAL/lFRNVIlWJyQWCkAK4RkxUiVQlJhcIQgrgGjFRJVKVmFwgCCmAa 8RElUhVYnKBIKQArhETVSJVickFgpAC5A2NiSqRqsTkAkFIAfK Ggh8ndcf B8EKJSaqRKoSkwsEIQVwjZioEqlKTC4QhBTANWKiSqQqMblAEF IA14iJKpGqxOQCQUgBXCMmqkSqEpMLBCEFsmu8H/XxjtK3L73armHktvB6AWq7/DQJplEwk4JcGSD2PqohVacqMbmAa6TA6RpfvyDvco3AXndc/qWDH6/Bk4yYuaF9NHuqTlVicgHXSEGZrtEN6/fpv8mNlPbr1WS6zn3zjDIUrIGKvKHZgWukoLgVyuY4Q9f045Jv x3KgkaYDPVo7nOX4lM8z jn2QEXe0NzANVLgtxv6ar/0DdduqJFqS8R2DZKTysc1aDIvM8VwzJX6eaAib2he4Bop8HyG8 mrrRyrXcOfv3Di5xjFT NQ1hDyjX8AMVOQNzQpcIwWiazzqI vf8VcOIrlG3xzjdfRbGzCucdT2kWuIeUY/hx2oyBuaEbhGClxzjWNj47uJxtk1Zpqw0 8voa2Xnz4hHOmP3cCktewGcgjNfGk/hrTyjH7KZD7srJA3NDdwjRTgt7xiokqkKjG5QBBSANeIiSqRqs TkAkFIAVwjJqpEqhKTCwQhBXCNmKgSqUpMLhCEFMA1YqJKpCox uUAQUoC8oTFRJVKVmFwgCClA3lDw46Tu2P8g97kGAOA3gGsAAM KAawAAwoBrAADCgGsAAMKAawAAwoBrAADCgGsAAMKAawAAwoBr AADCgGsAAMKAawAAwoBrAADCgGsAAMKAawAAwoBrAADCgGsAAM KAawAAwoBrAADCgGsAAMKAawAAwoBrAADCgGsAAMKAawAAwoBr AADCgGsAAMKAawAAwoBrAADCgGsAAMKAawAAwoBrAADCgGsAAM KAawAAwoBrAADCgGsAAMKAawAAwoBrAADCgGsAAMKAawAAwoBr AADCgGsAAMKAawAAwoBrAADCgGsAAMKAawAAwoBrAADCgGsAAM KAawAAwghzjb6peLpB/M7YN1XTj97ll4yLCqvJoauqz rzEvaxWp/KASiKT ca/r0/lWuY310K9bsGAOVTqmt0XUe/PPZN13VwDQBuIKprjMYKZv14ObLvzFKrBvpNx2rnOLYbBmIbY9 80fU9dg1S41zf2TdX16wdLKdcuFTZ06yfWWVCV7Fmfytfj4T6g fCK6xtBZI3T5yVg7HMWkBlLoM6zWw8e Id9p nHomFbsFk/D/dzu/q9TNbsw8onjrMlp7B/ANUD5xHONcRzZA4yxaZU3/WiNu/n8M9f0evtfD1umHbtrWBXsP1pKpHYXYUPfnCYO3Fk4zpo7CbgG KJ/Y xpDZ8/W7fFjDs7Rmsif5vl801U3zPPQLRWv/6euYe15WD51VMO1yy1uuLkD fF81rSMnj1cA5RP5BWKOYn3do2gcXTc9vc5xmYeoa7BtrvVP3T SLgz9UThrOywVv3IBoEDiuYY1VvcxJ403Y4USMpCMTYWm77tjh EYyNZEgBuxUrumIxh7uuezkM7axvZKAMolqmuYu4XENTx2Q/fKLk3ktL95LAmud0PtSQjTLjnsOMLhGuxZW5smwnwHgBKJua9B VvfLIw1yd 07e5EvPnm9GlS2J5CnpNdPXq3KuXbPwpp lPc1 LOe c0OuAb4AfAeCgAgDLgGACAMra7BPhf1Wb8AABKj1TUAAFqBawA AwoBrAADCgGsAAMKAawAAwoBrAADCgGsAAMKAawAAwoBrAADCg GsAAMI4XOP/AADggeEauS0MAFAAtmtMAADgBK4BAAjDcI0nAABccbgGAAD4cN OT17 /v6T1f8/z cwt4ZoiRKYGQZjn fl8qlihzCk3Nf7 /tJVHoWlL ZWcUERIlODIEzTBNdQQRF9sQiRqUEQJriGEoroi0WITA2CMME1 lFBEXyxCZGoQhOkfdI1Xu Ubrx/vR92 POt4tVVV1Y8PWn8/6lOu8/rxNo7Z Iib/n4 OJH7UaHDJgjiuHaPo kBvYg FxWmeKDkLH1u13j1VbV5hPLVfd2jWmaXu2nrrH0ple7NrcVHNA 72Kut65qoVNO37Nvs 1HXj1frP1R2vCIZYOk3Ql3j8rI6KTsIGVu/1zWcUwty5yAHkRtK yKXmd5ovEf13r3OWK7xeGyHUtcwbvDvQ0Zdt5tAQ/9HIh1YrrGG07QN w7MRcyI5PmkmFpI3GKfVCjnFQpzWdmTmn4qCPc3unOva8i3xUd Nrtar3a7Eqz2KjSklvau8H7XnlQtwjfcm1nCN1/7tR71V9X7US3/a5lG7N34m0oE1YLZ2jHvm4cxvGlQxkvxJGfUbRD pUPxcgz2pnwrCzS1SdLjGaQ6yHmgdvw9gZkXrNY0Mco21OeoaZ rvH4FwO2Gpfz ZTkQ6MAUNOhjkvwzLkSEonNU0TO2ASnFQoXq7BntRvBeHeBg1u X6GwrhzqGp9ucIS5xqLrQRo1Z68XrvGpSAemSLnfWpYxOSPJnt Q0TfxtNv5JheLhGsJJ/VYQMraeYTfUuANuvd3cx9qvitEfXu0xpTTr8SXUNYx57OnWdOU aH4p0YDxDMTvug27f0nm4O5LSSa11bvWQTezoJxXKtWuIJ/VTQcjYeoYnr3R6x28vVda13UvbYwyb9VxOEeUZ6Ir15LXad8WO TRZaSd22dVVV7WMral bw7zps6EgkZfsImtDoyHZnoNwG340ksxJMcE3lMc9qVCoa0iXV TypHwrCvQ0a4Le8Vor43aEiRKYGQZjgGkoooi8WITI1CMIE11B CEX2xCJGpQRAmuEY0uF8w9l9zFtEXixCZGgRhgmsooYi WITI1CAI07/jGn4ZCXOyhEI5RYhMDYLwVOIaSc/wDwDwK AvNq5M05RbwjVFiEwNgjDnDsJNK5Sn gyxRfTFIkSmBkGYcwcBrrFSRF8sQmRqEIQ5dxDgGitF9MUiRKY GQZhzBwGusVJEXyxCZGoQhDl3EOAaK0X0xVwix75p lFJPQjCnLu7ulyD5t2N7hpDV1VVFeUyRIFchkVateijx4x9sxU zsocu elYfUWK4a7T0n cWDf4HE Z3zhul2zfqke0iyp6qiFr0h5EK46tl2PFDR3PUpd470kQvsole 2la4x9U3XDPHQqXWOe5/WOwAqMdc/5ACpSiuHQHf3ekDp0ezk1OPF40hAtFK dWf95uFv1EA1DR4fM2De86RQQhMuObVcuBO2yHqWusZLGNVYUu 8badTmF517lnoOkEznPFzGkUs3BOHTcHZUbMKwDMO0aBczIF o5Hx7iGpIYq/LbgnCl5zxhcQYNrsE0rtg1tgvIdCxprnHDHMR7wGzTcCqe3NbG vjEnxNzx25GeA8MeAKfFnWvSTg8OXKGwYtbS24PgLj/X4w4aXKMo1yC3hPNdpgTX2D80pj906c7e0E9bM/IEIcw15HpOY9cWdPpMcxCc5Uw9cI3fcQ2yHcpvm5XiGtIk3LPc dUbcVoK0ynBE7GpVx jUHARHOVuPI2iu uEaN5 wxESfoZidybqYyl1j2UfbPuTv47Szyse7diKYazf2HdlcNLYPu HroBqSln25DfDbXyBYEsVyoRwyas361riEmrY3hGvbNnLf8W1k vw2g9DdyVNv1oq946l1SeTOTMtXrEUHhyTL/APEO0j5dM0HHtjg2Jy4mGsXlhKzo 4zqG5iBI5Y47Chu0ywGi1DXigt/yisKNImP99kn832JBEObc3RWusQLXKAUEYc4dBLjGShF9sQiRq UEQ5txBgGusFNEXixCZGgRhzh0EuMZKEX2xCJGpQRDm3EG4KW8 oXCMKRYhMDYIw5w7CfXlD001kAPgHST1gHWCFspL3MnhShMjUI Ahz7iDANVaK6ItFiEwNgjDnDgJcY6WIvliEyNQgCHPuIMA1Vor oi0WITA2CMOcOAlxjpYi mEskUmbOCALB5Rr732j//rXXs2vwOSPzcVyG7c2hJZcX86JTPqy gpSZjoPLC4KQpJbtfEpd49XuZvFqq6p9xXQNMWdkPuhlMBIdOF VvhlLJFJmlh4ET53nDqjUNSjvRx3XNShXaSJvwss1jNep7YQO2 wdNw748Tsu5epZ7S9cJt8KTyL0qpMwsNwhSu1dJWAtwjVf7XXI Np2tI ZTuxnINM7nBfgcY9qtH87iY15u/exhJaOR6drNg73jeA YfS5lZbBCkdi Co9013o/66 WJ6BrunJH3MslzjeMCmnYiZFHhOqJVLtQjtsuJdBxGm/8nUmYWGwSp3YJd4/2oI/0RJcY1PHJG3oqHaxjdSVxYkbuZUC7WE9015Kncb6XMLDYIUrsX wVHrGq/226x/DteQckZm5No1qOWbsySjP5ALzpfL9URxjX8xZWaxQRDbdQdHqW u896euKzF3Q505I3OxX4ZdHX3yunQCIrzpumZXbp7PcTZSOVuP o92zyNlc/CyHMp/8esrM8oMg6BSCwwbhfvBbXit5L4MnN4pEyswZQZCAa6zANUoBQ ZhzBwGusVJEXyxCZGoQhDl3EOAaK0X0xSJEpgZBmHMHAa6xUkR fLEJkahCEOXcQkDd0pYi WITI1CAIc 4gIG8oAEWSesA6wAplJe9l8KQIkalBEObcQYBrrBTRF4sQmRoE Yc4dBLjGShF9sQiRqUEQ5txBgGusFNEXixCZGgRhzh0EuMZKEX 0xl0ikzJwRBMLlm/JVVUV4 VV4U55/PSkLx2Ww3kDSIW/B6iu/kzKTFhsvN14nNCs9CGwCXev9Tq 3n2/E603596P Ms2G4035WBb JfQyWDm4NMhbsEQWnTLT0uNOJ0H5pSBICXRpCHyzut2Ib97QuK 5BUe4adtocbg5iv/rvzA8aS TeRKEpM8XUmCGucdXoWp/aIFjtsp xxZpd49UmW6HQHBK3nzWD5Bo0b4plJvTudGT7pP4g5AeNInJro tSUmWKSu8AVitxoAUGwvsMUC16i2TUO80g311CyBLBcg5kjnJI JcStj81TEPKMRRK4UmzLzMjWm1P4vBYFqYj TJiAFuMb3acqdz1BUpCmf2LmGsdh06jxbhtn9ovwBh9ABI2vOn zLTby D0flLQZivEuhKcVHqGo/6yPr3/Z9RslzDJ63jzfCuse9vzfPsmBYZlrH1OTk/aBSR89FakSkzpdSYNJQjt677pSBcJNCVbzVKXePY1EiyryGmS8 zFdH7yuglbbgbHv09rDke2yL2I5hmNIPIXUmaKqTFJ2Ji 8TtBuEqg65ifqnWNmOC3vKJwo0ikzJwRBAm4xgpcoxQQhDl3EO AaK0X0xSJEpgZBmHMHAa6xUkRfLEJkahCEOXcQ4BorRfTFIkSm BkGYcwcBeUNXiuiLRYhMDYIw5w4C8oYCUCSpB6yD 1wDAPAb/AcxYrup0zpGzwAAAABJRU5ErkJggg==
دو تا table بنام های Table_Amar و Table_Morekhsi بصورت تصویر زیر دارم.
می خوام کوئری بنویسم که وقتی تاریخ (مثلا 1393/11/20) را بعنوان شرط قرار می دهم بیاد افرادی را که در این تاریخ در Table_Morekhsi در مرخصی هستند را در Table_Amarدر فیلد Hozor مقدار False و فیلد DateHozor را مقدار تاریخ حضور قرار دهد.
کد رو بصورت زیر نوشتم ولی مشکل اینجاست که میاد رکورد اول را که در Table_Morekhsi هست را در Table_Amar را برابر false قرار میده در صورتی که شرط برقرار نمی باشد.
update Table_Amar Set Hozor='False' ,
DateHozor=(select Table_Morekhasi.Tadate from Table_Morekhasi
where Table_Morekhasi.Code_T=Table_Amar.id and '1393/11/20' between Azdate and Tadate)
where exists(select Table_Morekhasi.Code_T from Table_Morekhasi where Table_Morekhasi.Code_T=Table_Amar.id)
http://barnamenevis.org/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAWcAAAFBCAIAAAA kL/nxAAAd10lEQVR4nO2dTbazKhOFHZUNR2PjLNf6RpKuQ0g/fYeRCdj8JuAMvA3/CqxCSECKvPtp3PseYmBbwhbwWKeaAQAghCq3AABAYcA1AABhwD UAAGHANQAAYcA1AABhwDUAAGHANQAAYcA1AABhwDUAAGHANQAA YcA1AABhwDUAAGGIrtE3FU83iJWNfVM1/ehd7s3YN1X1XRUAgEh4zDX8x3wq1xj7puq6zulYAICbKME1hq6 qumHsG9gGAAr41DVGYwWzfrwc2XdmqVUD/aaXCQzdUpVpG0udw1HZfohdtSi169dP4EUABPCZawydNX6Xn4z tBzLIjxqMke83BdlMg/nyYUyrMxg/Lkc6pcIuAAjnI9cYx5E9wFpEGOVNP1pDeD7/zEAPofUzbbFN 0kFAHjzxb7G0NkT/7FvWFPYajDXCvY6hsX0FXb wom0fuSl4pkMAJ/w QrFXA94u0bYUDWGu7Fl4esaDqlwDQA 4SPXGDqjYN95kIausUIJGKvMMmIv8nQNT6kAAG8 dQ12H9JzN3Sv7MJE2L2HrdDfNUSpcA0APuHDfQ2ycmj60VyJ7E 9eraekzJNX57gVNixX4xl89zVcUuEaAISD91AAAGHANQAAYShw DfZ57PUzWQBAHhS4BgCgKOAaAIAw4BoAgDDgGgCAMOAaAIAw4B oAgDDgGgCAMOAaAIAw4BoAgDCqeZ6rqpoAAMAPuAYAIIxqnucn AAB4s7rG/wAAwI/DNZJun/z9/X1Zw/P5jKIkKapEqhKTi fzmXs6/4MYrpGumb /vy9rWMZAFDHpUCVSlZhcwDVSANeIiSqRqsTkAq6RArhGTFSJVC UmF3CNFMA1YqJKpCoxuYBrpOBu13i1Zpa/9nU69tVWVVU/rNJ9DCw11I/3NE3vR73Wczo C8dA3c6zfZn/ziLmCFMaIQpOVgKukYI8c433o16GvcCrlV1j biut275ftQ6LGMyRb4f9TFyXu39w8iYa1ABr9ZnUFP5l2Q/WQm4RgrUuAa5H7ava9d4PLauSV2DzGTW pdq67rdKjZuhPQmHMN6PF2DtHqU2hMCooc9fimsH /ti/ZIFV2Dxv8cMUaKoJIozH6yEnCNFChxjVd7dNqLFcq0uMZ7/a/pGi/az9ae9X7Ux S5fZEuTlW8H/X3xmG5hjku3ruwo9VXuzd6DLy3cYh0/PrjHqtXa40kh2scP7IRW39kRqYUsewnKwHXSIEO11gNwPjYquH sGuth9GCz8x79cutqS9HaZU931O8X4465xjH3MRuxTt0aRRfH2 18WxYiuwUZsmibWNeSIZT9ZCbhGCkp2jaWbPfaD6YTFvJuxrsH tnnzJt65hjaLL4z91jS3 QsSmaeLnGmLEsp sBFwjBTpcw zUr9ZrhbIfux58mnRcuYY5aGJw7RrmJN8Yh8YoOsrF46ePXYME go2Y1S7ZPZUilv1kJeAaKVDz5JV 0LbnrQ3ryeuxeDZXy/vKum3rqqrax1bUvjaHWXfUtq2NJCuUN2l2V2xs0DoDUNHT54 /foQtP3k9DmYiZpg3U/c5YhpO1nFFfA8F3uC3vGKiSqQqMbmAa6QArhETVSJVickFXCMF cI2YqBKpSkwu4BopgGvERJVIVWJyAddIAVwjJqpEqhKTC7hGCu 5zDb MhC7mElKcqhKpSkwu0vXqf5bDNZJeuT8AwK9wU97Q75mmKbeEa 1SJVCUmFwhCCm5aoTy/znxbxOVXJVKVmFwgCCmAa8RElUhVYnKBIKQArhETVSJVickFgp ACuEZMVIlUJSYXCEIK4BoxUSVSlZhcIAgpcLkGzesb3TWGrqqq qulHT6Hk8i9frZbv02PGvtmKmWqHLqC5z6B9dNNC6AbHd93ivx FDQ723UjX9HsemH2k5DbAhWipXDFwjBaJrvJeEcB8lNbh0jbFv qm6Yh 4j19iqaHq2grFvUruDhCWyb8jQGo2fJCKKp2KGrmn25se 2dzWDODQEReWLk7IRcsPXCMFVyuUNK6x8oVrrGOQq E88KLfxj1FLhptPcZU6Vr8TKctTbMPeDJtsOdcZzFD1/R9t84P4BrgO0p1je3GbXT0Bel2fcMc5CSSc4dhGMgB1vyDtby9 ZOgOg6AHjn1zNg7bNcYt3nAN8B1lusbQ7aON/HNFk2twc43R2PHwEE 3E8gq42rX5Owaq1/ANcB3FOkaxq7cabxocw0TY0/2vNdxIXLotjkFM8lyiNkjPfZN1wuuQdzE ojqlMp1AtdIQYmuYQ8Yq uqdg06Mse 8ZhrGAXmJMt9OqxrrJa7aRjJGmk010twDSAhuoaYDzaGa9iTha vb5rxf/tHaK6BPD 1atyEplcdn4p 8SguUpuuaTY0o0lyKGModH1ExNEbrz8ac4nQVzlqW2qVyxcA1U oDf8oqJKpGqxOQCQUgBXCMmqkSqEpMLBCEFcI2YqBKpSkwuEIQ UwDViokqkKjG5QBBSANeIiSqRqsTkAkFIwU15Q Ea96NKTC4QhBTclzc03UQGAAepO/Y/CFYoMVElUpWYXCAIKYBrxESVSFVicoEgpACuERNVIlWJyQWCkA K4RkxUiVQlJhcIQgrgGjFRJTKXmFhvCUapR9UV RlcrvGo1zeUvn/t9ewafMYamePyb 9Q0feplLxDRfuonryhC1KiViNj6On4s2zpePI94wtSu1eJY 16pHaPci68cI0UuN553czi1VZV 4rpGuQt76HzG/P08hsvaJ/T8uTD6qN68oZKiVppcjCjafJeLH0lXzxe0C 1e5k41qrHU c5wHCNFHitUN6POq5rUDxzNHi5hpySk0 9KZVz9Sz3tK4TbsEnkbOmvKF70w5Lok2bF4XPACSkHeMuZnBeM NetwEyJaGYVOn0JrpECH9d4td8l13C6xnVOqgXLNejEn9x5 JScUupNqdxRz24W7PA uQbnDjnyhm5Ns6N0szFaA7mHn5IHcccL4p3tiuVCPUy7jlxkC3 CNFFy5xvtRf708EV2DS2YlMclzDXP0sNsIXOpNR7lQj9guJ3LW lDfUoZk2Yy8utlHKTgdPycTkCUKYa1ysOc0VE1wjAy7XeD/qSH9EiXGNsW CNv48XOMiJed PL NR1NyCvV85hpMM7fnDXVotj7 uNylPMQ1PHZ2jnYNg8EK5S6cGQC/XphIrmEsB/y4dg05JaeUepMvl uJ4BqZ8oZKmukSSdqXpiNTPt45QQhwDb4esd2x78jyDbuh9yC4 xnt/6roSczf0NLsO2g3dv02fvC6dT0jJKebXlMrZehztnkXOmvKGMr Ufli38 UtpSSccL00QpHalcnmiIf6ZziMIePJ6F/gtr5ioEnmjmFh/Qjf n JVdUV BrhGTFSJVCUmFwhCCuAaMVElUpWYXCAIKYBrxESVSFVicoEgpA CuERNVIlWJyQWCkALkDY2JKpGqxOQCQUgB8oaCHyd1x/4HwQolJqpEqhKTCwQhBXCNmKgSqUpMLhCEFMA1YqJKpCoxuUAQ UgDXiIkqkarE5AJBSAFcIyaqROYSg7yhP8/lm/JVVUV4 VV4U555GUniuPzWm0 B784mhfZR5A11txuaN5RNcWQF fItZBAFrzfl34/6yzQbjjflPW8p9PJb6a0iv/D0BVYfRd7QiHlD2USzNKY 2dVAFHzzhsZ1DcqXrmGnzRHe4 anJ84Unh/AugbyhkbPG8p xhbDNVLgdo1Xm2yF4kg/ySK5Bs3XIqXSPPrZUnokuXGl8PyAk2tw7oC8oVflzhuJkFhM8B K4Rgq85hrkrxxEdI0VzyWG5RrM7foylaZlGaevJHAN5A11thua N1RONCtNQOAaKfB8hvJtmnLnMxSvNOUTO9cwFrnOes6W4ZlnNA TWNUyQN/SiXKrHnWhWunpwjRSIrvGoj6x/3/8ZJcs1fNJVWvCuse rbVXx3cqwjK2vX6Xw/IBr10De0Ityvp6LRLOy5cM1UuCYa2ybGkn2NcQ0kBLT cnrscI3/32atDuyVO5FNM/ox0z8k1fkDbW/EpY39CrRrGOeCNdIAX7LKyaqRN4oBnlD/y3gGjFRJVKVmFwgCCmAa8RElUhVYnKBIKQArhETVSJVickFgpA CuEZMVIlUJSYXCEIKkDc0JqpEqhKTCwQhBcgbCn6c1B37HwQrl JioEqlKTC4QhBTANWKiSqQqMblAEFIA14iJKpGqxOQCQUgBXCM mqkSqEpMLBCEFcI2YqBKpSkwuEIQUXLrGq62 feFVdo2h835jbL/8NN9kaPLR9dvJUo1eiiRv3o2GeON1LiONluP9tILE5AKukYIL1 3jUVft41Glco2 qjk/4wkAv/9A1zf41 u65F17pPD7DR6T5drghJjhRXjlicgHXSIHLNdYUXu8krrG 3uidDMcaA32/5WGgriGl5CSvWncDGRtC6s2llNyBfe rPiJzuUZeMbmAa6RAdI33npYngWscqXQ do1x676Ga7ApOe0k216pN7dp/fJvT9vwEZnNNbKKyQVcIwXOv2xAiP XDQiheUON3n/KjmWvvK1uvh/vTr350eDwEZnRNTKKyQVcIwUez1DSrFBWvphrrN/u9zEgpOSUXMO9wRHLNWyRZsXmpgz9iAZGKi9ITC7gGiko2zWMF YeYktNIRUkzULpSR8VzDWtZRBOd0n/Pt7hGLjG5gGuk4MI19nVKir9sQJ/8XQqdzOeIx7fsv9yxfmjkATWyYHbm1sZ5hWIntfQfGD4ijQa4f VyjXam8NDG5gGukAL/lFRNVIlWJyQWCkAK4RkxUiVQlJhcIQgrgGjFRJVKVmFwgCCmAa 8RElUhVYnKBIKQArhETVSJVickFgpAC5A2NiSqRqsTkAkFIAfK Ggh8ndcf B8EKJSaqRKoSkwsEIQVwjZioEqlKTC4QhBTANWKiSqQqMblAEF IA14iJKpGqxOQCQUgBXCMmqkSqEpMLBCEFsmu8H/XxjtK3L73armHktvB6AWq7/DQJplEwk4JcGSD2PqohVacqMbmAa6TA6RpfvyDvco3AXndc/qWDH6/Bk4yYuaF9NHuqTlVicgHXSEGZrtEN6/fpv8mNlPbr1WS6zn3zjDIUrIGKvKHZgWukoLgVyuY4Q9f045Jv x3KgkaYDPVo7nOX4lM8z jn2QEXe0NzANVLgtxv6ar/0DdduqJFqS8R2DZKTysc1aDIvM8VwzJX6eaAib2he4Bop8HyG8 mrrRyrXcOfv3Di5xjFT NQ1hDyjX8AMVOQNzQpcIwWiazzqI vf8VcOIrlG3xzjdfRbGzCucdT2kWuIeUY/hx2oyBuaEbhGClxzjWNj47uJxtk1Zpqw0 8voa2Xnz4hHOmP3cCktewGcgjNfGk/hrTyjH7KZD7srJA3NDdwjRTgt7xiokqkKjG5QBBSANeIiSqRqs TkAkFIAVwjJqpEqhKTCwQhBXCNmKgSqUpMLhCEFMA1YqJKpCox uUAQUoC8oTFRJVKVmFwgCClA3lDw46Tu2P8g97kGAOA3gGsAAM KAawAAwoBrAADCgGsAAMKAawAAwoBrAADCgGsAAMKAawAAwoBr AADCgGsAAMKAawAAwoBrAADCgGsAAMKAawAAwoBrAADCgGsAAM KAawAAwoBrAADCgGsAAMKAawAAwoBrAADCgGsAAMKAawAAwoBr AADCgGsAAMKAawAAwoBrAADCgGsAAMKAawAAwoBrAADCgGsAAM KAawAAwoBrAADCgGsAAMKAawAAwoBrAADCgGsAAMKAawAAwoBr AADCgGsAAMKAawAAwoBrAADCgGsAAMKAawAAwoBrAADCgGsAAM KAawAAwghzjb6peLpB/M7YN1XTj97ll4yLCqvJoauqz rzEvaxWp/KASiKT ca/r0/lWuY310K9bsGAOVTqmt0XUe/PPZN13VwDQBuIKprjMYKZv14ObLvzFKrBvpNx2rnOLYbBmIbY9 80fU9dg1S41zf2TdX16wdLKdcuFTZ06yfWWVCV7Fmfytfj4T6g fCK6xtBZI3T5yVg7HMWkBlLoM6zWw8e Id9p nHomFbsFk/D/dzu/q9TNbsw8onjrMlp7B/ANUD5xHONcRzZA4yxaZU3/WiNu/n8M9f0evtfD1umHbtrWBXsP1pKpHYXYUPfnCYO3Fk4zpo7CbgG KJ/Y xpDZ8/W7fFjDs7Rmsif5vl801U3zPPQLRWv/6euYe15WD51VMO1yy1uuLkD fF81rSMnj1cA5RP5BWKOYn3do2gcXTc9vc5xmYeoa7BtrvVP3T SLgz9UThrOywVv3IBoEDiuYY1VvcxJ403Y4USMpCMTYWm77tjh EYyNZEgBuxUrumIxh7uuezkM7axvZKAMolqmuYu4XENTx2Q/fKLk3ktL95LAmud0PtSQjTLjnsOMLhGuxZW5smwnwHgBKJua9B VvfLIw1yd 07e5EvPnm9GlS2J5CnpNdPXq3KuXbPwpp lPc1 LOe c0OuAb4AfAeCgAgDLgGACAMra7BPhf1Wb8AABKj1TUAAFqBawA AwoBrAADCgGsAAMKAawAAwoBrAADCgGsAAMKAawAAwoBrAADCg GsAAMI4XOP/AADggeEauS0MAFAAtmtMAADgBK4BAAjDcI0nAABccbgGAAD4cN OT17 /v6T1f8/z cwt4ZoiRKYGQZjn fl8qlihzCk3Nf7 /tJVHoWlL ZWcUERIlODIEzTBNdQQRF9sQiRqUEQJriGEoroi0WITA2CMME1 lFBEXyxCZGoQhOkfdI1Xu Ubrx/vR92 POt4tVVV1Y8PWn8/6lOu8/rxNo7Z Iib/n4 OJH7UaHDJgjiuHaPo kBvYg FxWmeKDkLH1u13j1VbV5hPLVfd2jWmaXu2nrrH0ple7NrcVHNA 72Kut65qoVNO37Nvs 1HXj1frP1R2vCIZYOk3Ql3j8rI6KTsIGVu/1zWcUwty5yAHkRtK yKXmd5ovEf13r3OWK7xeGyHUtcwbvDvQ0Zdt5tAQ/9HIh1YrrGG07QN w7MRcyI5PmkmFpI3GKfVCjnFQpzWdmTmn4qCPc3unOva8i3xUd Nrtar3a7Eqz2KjSklvau8H7XnlQtwjfcm1nCN1/7tR71V9X7US3/a5lG7N34m0oE1YLZ2jHvm4cxvGlQxkvxJGfUbRD pUPxcgz2pnwrCzS1SdLjGaQ6yHmgdvw9gZkXrNY0Mco21OeoaZ rvH4FwO2Gpfz ZTkQ6MAUNOhjkvwzLkSEonNU0TO2ASnFQoXq7BntRvBeHeBg1u X6GwrhzqGp9ucIS5xqLrQRo1Z68XrvGpSAemSLnfWpYxOSPJnt Q0TfxtNv5JheLhGsJJ/VYQMraeYTfUuANuvd3cx9qvitEfXu0xpTTr8SXUNYx57OnWdOU aH4p0YDxDMTvug27f0nm4O5LSSa11bvWQTezoJxXKtWuIJ/VTQcjYeoYnr3R6x28vVda13UvbYwyb9VxOEeUZ6Ir15LXad8WO TRZaSd22dVVV7WMral bw7zps6EgkZfsImtDoyHZnoNwG340ksxJMcE3lMc9qVCoa0iXV TypHwrCvQ0a4Le8Vor43aEiRKYGQZjgGkoooi8WITI1CMIE11B CEX2xCJGpQRAmuEY0uF8w9l9zFtEXixCZGgRhgmsooYi WITI1CAI07/jGn4ZCXOyhEI5RYhMDYLwVOIaSc/wDwDwK AvNq5M05RbwjVFiEwNgjDnDsJNK5Sn gyxRfTFIkSmBkGYcwcBrrFSRF8sQmRqEIQ5dxDgGitF9MUiRKY GQZhzBwGusVJEXyxCZGoQhDl3EOAaK0X0xVwix75p lFJPQjCnLu7ulyD5t2N7hpDV1VVFeUyRIFchkVateijx4x9sxU zsocu elYfUWK4a7T0n cWDf4HE Z3zhul2zfqke0iyp6qiFr0h5EK46tl2PFDR3PUpd470kQvsole 2la4x9U3XDPHQqXWOe5/WOwAqMdc/5ACpSiuHQHf3ekDp0ezk1OPF40hAtFK dWf95uFv1EA1DR4fM2De86RQQhMuObVcuBO2yHqWusZLGNVYUu 8badTmF517lnoOkEznPFzGkUs3BOHTcHZUbMKwDMO0aBczIF o5Hx7iGpIYq/LbgnCl5zxhcQYNrsE0rtg1tgvIdCxprnHDHMR7wGzTcCqe3NbG vjEnxNzx25GeA8MeAKfFnWvSTg8OXKGwYtbS24PgLj/X4w4aXKMo1yC3hPNdpgTX2D80pj906c7e0E9bM/IEIcw15HpOY9cWdPpMcxCc5Uw9cI3fcQ2yHcpvm5XiGtIk3LPc dUbcVoK0ynBE7GpVx jUHARHOVuPI2iu uEaN5 wxESfoZidybqYyl1j2UfbPuTv47Szyse7diKYazf2HdlcNLYPu HroBqSln25DfDbXyBYEsVyoRwyas361riEmrY3hGvbNnLf8W1k vw2g9DdyVNv1oq946l1SeTOTMtXrEUHhyTL/APEO0j5dM0HHtjg2Jy4mGsXlhKzo 4zqG5iBI5Y47Chu0ywGi1DXigt/yisKNImP99kn832JBEObc3RWusQLXKAUEYc4dBLjGShF9sQiRq UEQ5txBgGusFNEXixCZGgRhzh0EuMZKEX2xCJGpQRDm3EG4KW8 oXCMKRYhMDYIw5w7CfXlD001kAPgHST1gHWCFspL3MnhShMjUI Ahz7iDANVaK6ItFiEwNgjDnDgJcY6WIvliEyNQgCHPuIMA1Vor oi0WITA2CMOcOAlxjpYi mEskUmbOCALB5Rr732j//rXXs2vwOSPzcVyG7c2hJZcX86JTPqy gpSZjoPLC4KQpJbtfEpd49XuZvFqq6p9xXQNMWdkPuhlMBIdOF VvhlLJFJmlh4ET53nDqjUNSjvRx3XNShXaSJvwss1jNep7YQO2 wdNw748Tsu5epZ7S9cJt8KTyL0qpMwsNwhSu1dJWAtwjVf7XXI Np2tI ZTuxnINM7nBfgcY9qtH87iY15u/exhJaOR6drNg73jeA YfS5lZbBCkdi Co9013o/66 WJ6BrunJH3MslzjeMCmnYiZFHhOqJVLtQjtsuJdBxGm/8nUmYWGwSp3YJd4/2oI/0RJcY1PHJG3oqHaxjdSVxYkbuZUC7WE9015Kncb6XMLDYIUrsX wVHrGq/226x/DteQckZm5No1qOWbsySjP5ALzpfL9URxjX8xZWaxQRDbdQdHqW u896euKzF3Q505I3OxX4ZdHX3yunQCIrzpumZXbp7PcTZSOVuP o92zyNlc/CyHMp/8esrM8oMg6BSCwwbhfvBbXit5L4MnN4pEyswZQZCAa6zANUoBQ ZhzBwGusVJEXyxCZGoQhDl3EOAaK0X0xSJEpgZBmHMHAa6xUkR fLEJkahCEOXcQkDd0pYi WITI1CAIc 4gIG8oAEWSesA6wAplJe9l8KQIkalBEObcQYBrrBTRF4sQmRoE Yc4dBLjGShF9sQiRqUEQ5txBgGusFNEXixCZGgRhzh0EuMZKEX 0xl0ikzJwRBMLlm/JVVUV4 VV4U55/PSkLx2Ww3kDSIW/B6iu/kzKTFhsvN14nNCs9CGwCXev9Tq 3n2/E603596P Ms2G4035WBb JfQyWDm4NMhbsEQWnTLT0uNOJ0H5pSBICXRpCHyzut2Ib97QuK 5BUe4adtocbg5iv/rvzA8aS TeRKEpM8XUmCGucdXoWp/aIFjtsp xxZpd49UmW6HQHBK3nzWD5Bo0b4plJvTudGT7pP4g5AeNInJro tSUmWKSu8AVitxoAUGwvsMUC16i2TUO80g311CyBLBcg5kjnJI JcStj81TEPKMRRK4UmzLzMjWm1P4vBYFqYj TJiAFuMb3acqdz1BUpCmf2LmGsdh06jxbhtn9ovwBh9ABI2vOn zLTby D0flLQZivEuhKcVHqGo/6yPr3/Z9RslzDJ63jzfCuse9vzfPsmBYZlrH1OTk/aBSR89FakSkzpdSYNJQjt677pSBcJNCVbzVKXePY1EiyryGmS8 zFdH7yuglbbgbHv09rDke2yL2I5hmNIPIXUmaKqTFJ2Ji 8TtBuEqg65ifqnWNmOC3vKJwo0ikzJwRBAm4xgpcoxQQhDl3EO AaK0X0xSJEpgZBmHMHAa6xUkRfLEJkahCEOXcQ4BorRfTFIkSm BkGYcwcBeUNXiuiLRYhMDYIw5w4C8oYCUCSpB6yD 1wDAPAb/AcxYrup0zpGzwAAAABJRU5ErkJggg==