¦U¦ì¤j¤j¦n,·Q½Ð±Ð¦p¦ó¤USQL »yªkªº°ÝÃD
Aªí:
ID,©m¦W
1,ªô¥ý¥Í
2,¶À¥ý¥Í
3,³¯¥ý¥Í
Bªí:
ID,ª÷ÃB,µ²²M»P§_,¤é´Á
1,100,FALSE,2019/1/1
1,100,TRUE,2020/1/1
2,100,FALSE,2019/1/1
2,100,TRUE,2020/1/
3,100,FALSE,2019/1/1
¹w´Áµ²ªG
©m¦W(¥ÎID¤ñ¹ï),ª÷ÃB(¤£ºÞµ²²M»P§_¡Aª½±µ¥Hid¥[Á`),¤é´Á(¥u§ì¨úµ²²M»P§_¬°TRUEªº¤é´Á)
ªô¥ý¥Í,200,2020/1/1
¶À¥ý¥Í,200,2020/1/1
³¯¥ý¥Í,100,NULL
½Ð°Ý³o¼Ëªº¹w´Áµ²ªGn¦p¦ó¤U»yªk?(¥Dn¬O¤é´Á¥u§ì¨úµ²²MÄæ¦ì¬°TRUEªº¤é´Á¡A¦P®É¤Sn¥HID¬Û¦Pªº¥[Á`ª÷ÃB)
³o¨âÓ²V¦b¤@°_
¤£ª¾¹D¸Ó¦p¦ó¤U»yªk... |