永洪社区
标题: 数据连接问题-日期 [打印本页]
作者: yhdata_34fdb73b 时间: 2022-10-21 17:25
标题: 数据连接问题-日期
表1和表2连接,如果表1 month 落在 表2的 from和to范围,则匹配对应周期,可以如何实现?
用Join <=,>=连接行不通,版本为8.5
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJcAAACKCAYAAACn19g8AAAJaklEQVR4nO2cv2sbaR7Gn1m2uObyHySwRPKCIgLHhStm2uSMlEa3hWGLQ2wWZmCLyI0hHIZrRAi40aQIWGE3iCsCKnYFxjNkb5srrOLwcRAUw3kmLCTgPyDXXJO8V8iSJtL8kpV35pXn+YBIrFfvN69nHs07efXRq52dnYkXL15gc3MTJBwen3iijs9nAPD+/fvMB7RO8PjEE3V8tKdPn4oPHz5kPBxSBLSzszNxcHAA0zTzHou6/PdfeY9AfX77+4WnPsthGKQgMFxEGgwXkQbDRaQhLVyupcFyZVUnY97Cvn0P9uu8xxEOr1zrxM8PYTx5m/coUsNwrRG+7+c9hKUICZcP2zBguzYsQ4OmjR+GZWP2q7mwNAsfzXq+DcMIvub8lZYRUWNdmUxFb2G37kG7cgva7Yfjqen1Eazbt6bPzd8V+E8ewrhy3n7lFozWUeB4vIV9+yFcfFxjMuW5rVsoP3iJ4YM/QbtyC9bPwcrhffImJFwlbFSH2K73Udn1IISAEB520Ud5yZuoUdvCaaM3q1FZvoaq9B//DRv3f4B4dwzvKx/bj5/DfvwGO78cQ7z7Cc4NH/XW0fT1/pN7KP/4BXb/fQzxbvyaXbRQDrwGAAatf6Cxfzyraz2HD6BmH8N7dBP6o58g3h1j/4/BsYT3yZvIaVHv9NCqlc5/KqG2vwuzO1h4N8aytfNxjdYFaijJS+DLP6N2ffxT6btvYT77O3D/a4x/26uo3b8D/dWb85N8hL0HJTi/fD3tA1xFzbZhPvs+cKX5Ebj7l1ndzTvQ//krvISxVJfukw2R4apulOaeqaFhjnC6xFviU9RQk5vY2rw691wJG9dDXwy8foPRH75AeaHBQOOblziZhusmKsEa16+hmmIsy/fJBt7QE2lEhmu0cHlxMehWMb4YlVHR565A3gmGS9UoENevoRo6VR1h8GzuynOJiAzXcLsJ252Ew4dr1dE1G6gBmNz09/fc8T2F78I+Bea9isUabYymNYqEgZ1HPuq3n8OdToFv4bZa6H7zLVpLhGv4nzcyBiiFyHCZnS2ctMvnywhltOHA25/ForbjoDqqo6xp0JoDbLQagd4+Tkd6SI1d9PaLFy0AKH33A7yvfkX7d5OliL+i/aUNzzbS19i8A/1Za7yMsQaLqaE+l2tpGDQECpqDRehzJUOfi2TJVHM2jPSX56Jx49r/8h6C8rx685uF5z6/e/cuDg4OcOPGjRyGtB68evWKxyeGqOPDaZFIg+Ei0mC4iDQYLiKNhHC5sDQNhr32nzQrjJ/gvK3aHnhNpO4U156mfjjx4XIH6Jomqtt7l0CTURPXGn9y4QWdt4B06dtN1Ofam4EQJPWH78IymjitRLgSCe2J9eM4OzsT+/v7IgzHhDCd2Z9FZTQaSarsCBOmcCKfW7VdCM/pCMcTQjimQMhJjG9Pri9E9PGJuXK5GHRNNGpArWGiO+C169NTw77Yj/4g3z/FSK/MeWA1NMwuxqcjoT+AUq2FWoyFEt+eXD+OyHD5dntmQdQal8QgXQPcwcwc8U4wrG5g/tyXK3q6/rLHl0BEuHwc9ocwG5MSwXcLkYZvw2hXLm6OrNr/E9cPD5d/iD462AnU4NQoGd+G0QR6R62FK1Um/SXUDw2Xf9jHcLg9drUmj3oX6LbBVQkJRJ24cgX66HThf2beCVApp+gve3wJhH5v8bA/hOmI86+EzR6OOUT/kOn6pMSduNIGqsOTOT16ThVXNFhAWLjcPWzPTYkTag0Tw/6hEt+Juxz4sJt9bPWiTlwNO50R6ta5Tn6uis9086T+sseXwPw6l2NC6B0vdN1CCE90dF1ENl9SpK1zeR2hAwILj+Ax9oRj6tM23XSEl7q/Jzp6WPtknSqhPdX4oo8Pt61MAX2ueOhzkcyh5kykQc05BZwW4+G0SDKH4SLSYLiINBguIg1qzrkjW3POQpMOh5pzzsjWnFetn6hJx0HNOZn11Zzla9JCUHNWFNma86r1kzXpOKg5q4ZszXnV+ktAzVklZGvOsjXoOag5q4JszVm2VBgCNWcVkK05r1r/glBzzhvZmvOq9VdhYSnCMQX0jgiVTePaLjHyliKSzV6vowtM7dNzK3W6JJDUf9X6AS6wFEHNOQVrqzmvWj9Rk44/PtScU0CfKx76XCRzqDkTaVBzTgGnxXg4LZLMYbiINBguIg2Gi0iDmnPu5K0xfwoNOhxqzjmjuubM3ZwlU1zNmbs5rzGqa87czflyobrmzN2c1xTVNWfu5rymqK45czfnNUV1zZm7Oa8pqmvOq1zxqDknU1zNOZ15TM15BQqrOXM3Z/nQ54qHPhfJHGrORBrUnFPAaTEeToskcxguIg2Gi0iD4SLSCA2XawU+U1xSbSXLkremnIPmPPtscUm1lSxF4TTnRa05THctDtSc48d8Ac2ZyKegmnNgBHCtNkadnQv/I2QJLpHm/HlUQ7euoXv+d9100GtltU1rgZloxEcrashR/WXXnyPFDb1Ar3GKpmHxCxoyKYrmPE+p1kJva4Q2HWc5FEdzJplSKM1ZLC5FeE5H6CiegTqBmnP8b5FacxZiHC4EtVbdFB2noMkS1Jzj+1NzXgn6XPHQ5yKZQ82ZSIOacwo4LcbDaZFkDsNFpMFwEWkwXEQa1JxzJ29NObndpua8nqitOfuwjSZOGr1ZFrCNspXSj6HmnExhNWevI/T5LbNCnqPmrCSKa86lFo4u6n+BmrN6KK05+7CbfVR30wUuMlzd+uSGfjxnU3POAFV3c/ZtGJoGTWviZKuHtN2pOauCyppzqYUjISBEDw00YaS8oafmrAKqa85TSqi1etgapdvVmzf0eaOy5uxa0NIuO4RBzTmZ4mrOjjABYQYsZK+jp16KoOacgsJqzkII4TnC1BFoX9wqnprzCtDnioc+F8kcas5EGtScU8BpMR5OiyRzGC4iDYaLSIPhItKg5pw7+WvMqXdrdi1oWnqBgZpzzqitOX80UljtEWJMskWoOSdTWM05gNfRhemEt1FzVhLFNecpLvb6W9hZ0jGk5qwaCmrOrtVGpbe8ZMjdnFVCxd2cfRtt7OLoAqefmrMqKKo5u3t9bC07H55DzVkFVNWcXQvtSg8XnbR4Q583CmvO7qCL4XY5sOZZRxdd1DUNqexnas7JFFdznme5pQhqzikotOb8EcuFi5pzCuhzxUOfi2QONWciDWrOKeC0GA+nRZI5/weRMxsCOSvLugAAAABJRU5ErkJggg==)
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUkAAABCCAYAAADaOiTfAAALO0lEQVR4nO2dz4vbZhrHv172sJfNHzDQQIg9Lc4QWHbYg0Qvw3RTuSR4wzJQSDFNWZn2UA0sE3owhIIJIblIObTYYRtMAwGztEPLSGk3DCzFPiyzLBTF7I4UBhLIH5C97KHl3YM8tmzZsuyxrEee5wNmsKT30avvq/fx+2ueN/Py5UuBWDjC/SsynO2XuLMxeGb/xgr0XAvf/OlcLHf+4Ycf8Oabb8Zie1b2b6zg8duDWhzdvwINRmw6TAs13ca+J0f3ceXz8zDubICCctR0i4NR7+/x8TjrMgV+EZvl/c9xE5/iw43gqY23r+Hg2yc4iunWP/30U0yW58fR/n1oN4HLm3ReLmq6bdx5iDduyrhyf7//rhzt44Z8E2+8TcNBAvR0WwxH2L9xBdf+fQ3bS+wggRid5P7jh1i/vDn6Rd74EJ/iWzyJyUv+/PPP8Rg+IQ+vrWBlxfvIuoPLDw1Qer/o6baBO62HuOzokLu6rWiPkXvYCrRokoSebvHgf39XVjTo2EbrmzsgVBSxkImvu50c3333HS5dupR0NlIH6zYbrNtyE193O0FOyy/7vGHdZoN1W24ytVpt6VqSDMMw8yIjhFg+J/nffyadA+a08evfJp0DJiaWsrvNMAwzL9hJMgzDhMBOkmEYJgR2kgzDMCHM3Ula5QzK1rytnpQXMDbXkTmzDvmzF0lnhmFmwEI5U8aJq5ZrQJYNuPPI0inhl0lnYCF8/yW28Wc4r95FNum8pInvb0F230Pro9eSzgkDBTWhJJ2JU8np6W5fOMsOckpcl9sbDONzki4MWYZhGSjLGWQy3kcu+5vmI5r8Y5rvVlkeY2OxWNo6Mn/8CnigIXPmOoxnL2BsXofxrIXy5joym496eXM/uwX5jNctz5xZh6y1fPk+TvcChnbdu2bzFoxnAI5tdY+RG22YAUtbR+6TH9H+5A/InFlH+fv+uXCdTjtR6pF3nb+OZOQyLHfIhmt5NmQD7oi65xplyBn/PayJ9zCcWB9+KfE5ySxW19rYLjSRrzgQQkAIBxU0kZtykNGulnFYbPRt5Ke3MS8U4wDir1eB9w2IV19AO+8db977O4q1A4gnXhfc/ew6cl+dQ+VfBxCvDiBefY0KNOS01oC95r0vsfrxFxCvDuBcdbF97xGMe8+x88RLY15wURhKk0YU4wDO7YuQbn8N8eoAtd97x6PqdHqJVo+scgnVfAWOEBBCwKnkUS0NOsHm3V0UGwKipQV6Qa4hI9fMo+II3z0KQ/fIoYD+PUQjj2ZhG+14BVg6At1tSW9AU46LJAulVoFa352udbS1M2hDm8FGrPwIvP4elPPH31u4+0kW5pN3fcdeg2IYUB/8xWstjkiX/egDqA/+Bnx8PNb5GpSP34L09PmStqyi6sSE1yMLu/YWGprSc35ZRUNlrY7dXiVpA/kdKCPHiCzc3V6D2dJ857NQaibUehWG271HXYVZ698DWQ0NXZrzky4/ASe5tjpcKgqKqo3DKWr9PGzEy0VsXfJNRjx7Dvt355ALXCej+P6P6Dwbkw4AkMXqeZwOIuvEhNYB9xB2exs5X1c5k8mgUAfsXiWRsPXOmFF09xC2lB9RDgqKahsdZ/w12Xe2wG5yOk7PxA3DUELS+91g36el8fQiNQJO0g409yzs1tfg/TDmkJeGWoROJzDGEW6DIOfPYu0fRwiOabew++Ai8qelpTgJ1ikyoXUgu4q1dmeEjhEZm97Cbl1CPjf+GnevyWOSUxJwku3tEozeNJsLq1xAXS3CW6HlDUo373Zn0VwLxiGgTrRRhd2zQREZO7ddFDYfwep1GV/A0jTU3/+gN9lzGmn/57nvG+sUlfB6pKCo1lHwz0a7Fspy1MXiCnZ0GwXZGJgR9+5RgdcYDd7DtQyUttlFTkvASar6FjrVXHecJIcqTDi1vntTdkys2QVvPKW0i1Wt6Evt4tCWRtiooFGj6yIBIPvRF3CuHqH6m+OlLTdRfd2AY8hJZy0xspfegvRAG/hPJdYpGhPrUc2BiWp/XLK0i3yjFrkhkdVacLY6qOaOxzRLqObD75GrdrBl6jwmOSUD8SStcga7RQHi/mwyHE+SWTS+eJJLU48YADxxwzAME0rGtu2li0x+4ez/ks4Cc8p4+vxXSWeBiYml3L7h6dOnuHDhQtLZSB2s22ywbssNd7cZhmFCYCfJMAwTAjtJhmGYENhJMgzDhDDGSVooZzKQDTIRKVKAOyGGJvXzSZH0c4efdw1fPMbjz8Swf0k/0yQoakYYMQpTFVBVoUIV5sgLaGPb9sLvaaoQkmoKRwghhCNMXRKQ9O53IRxdEhg6L6lm5PRx2xeCdRtl39EloU6oBMO6USjLMCholiZGOklThVDN/t+0sfjKbo74QfEfo37eg3ULHotSBwZ1Sz7P4dDQLE2M6G57wTqLCqAUVdR3U9xMXhgKaiLk/25HxvbzAhB48k5IH7v9pKCuGwB0o+pEhnpZUtSMNgEn6RrVfrQSpUgsoniKsHb7kY+cDtprq4EQ/Ll8SKgBf/ok7CcFQd06e769ZCJH6ok3T1PZTyB/J9aMEENO0sVesw21eCzX8C8EEwnXgFzNzx75aFL6uO0nBTndXBzabdidIhrHe9FseSHKIk+UUC9LipoRY9BJuntoQseOTw/uck+Ja0AuAY0RmzfNJX3c9pOCpG5ZaC2Blm+fmKzWgI4m9qLU+KTK0ipDluX+Z9zsN0XNCDLgJN29JtrDe28U6kBvcyEmlHEvVS4PyT4MvKhOB4NjN7O+tPOynxTUdRsgi9W1EzzTvPIUZl+podVq9T+1EddQ1IwoA/tu7zXbUM3gvhum2kYzrT8DiyLspRsZSn9oS4uT/KrPw35SkNZtVLRwF4f2CZ7pxHmKYH8SFDWjTG+e21THr7UKO0eQxS9lcYQuSUIPESiwtkz1vkdLH7d9D9Zt2H53zaA+tGZwaH3LoG40yjLEOgnN0kTPSXoPNk6ZkxbMYll4ZXd0IQECgY9fs+7L1D3XX6wbIX3c9ruwbkP2u+f1gfPBxsKAbkTKcmbNF6RZmuB4kkwP1m02WLflhgNcMAzDhLCU2zcwDMPMC+5uMz1Yt9lg3ZYb7m4zDMOEwE6SYRgmBHaSDMMwIbCTZBiGCWHASVrlwZDrdEL8p4GkQ/ZHCenfvYZUKP2kdZl83ph6qwTqZUlRM7oEWpL9/912UMk3kUtxiKNFYpVzqKICZ4x2rlFCYeh8yfeCT0p/UvtwLZTlEg7ztCIN0NbNhSGX0Ck2+nUC28hNcEzUy5KiZqTx//tNMOz6NGHh6cDbEASPOaYuTEd09y8aXaKs29AxRxfScMyCEccWu31DtLIcDw3N0gSPSc4F+tsQZBUNCqnwPwB53bIaWlNH2qFelhQ1o02Ik3Rhlauw9R16If7TAMFtCFIBad1cGKUm1ipTOgHqZUlRM0IEnGS9cDxx441LNLS0PlqCkAupnxKo6uYa3f1aSuhsNTBVcuplSVEzYoRM3Ag0iocopXwTn4VDchuCFEBZt6yGlhAQooEiSpCjTkIkVZaJbt/QZVbNCBI6JplVNDS2bFR574ZopGobAkKkRrcsFK2BLTvCdiZJliWp7Rum0IwoPHEzL0hvQ0AYyrpZ5dnWIVIvS4qaUcY/1T28BMgxdSFFjXhMCN6GIBhSvwepJUDUdTOFCgjVdAauD18CRKMsQ6yT0CxNBJwk/CHbJVXoZvoejbchGA6p7whdGpV+cL0b6zZiKwLHFKpPu8S3b4hYljNrviDN0gTHk2R6sG6zwbotNzwmyTAMEwJv38AwDBMCd7eZHqzbbLBuyw13txmGYUJgJ8kwDBPC/wFnYqCwux3QlgAAAABJRU5ErkJggg==)
作者: yhdata_ruby 时间: 2022-10-21 17:35
你的SQL语句怎么写的
作者: yhdata_yzm 时间: 2022-10-21 17:37
产品暂时无法实现该功能呢,你可以通过sql试一试,判断一下是否在from to周期内,在的再在数据库里插入一行
作者: yhdata_34fdb73b 时间: 2022-10-21 17:49
SELECT * from a LEFT join b on a.pub=b.pub and (a.month >= b.`from` AND a.month<= b.`to`)
作者: yhdata_ruby 时间: 2022-10-21 17:54
SELECT * from a LEFT join b on a.pub=b.pub where a.month between b.from and b.to你试试这个
作者: yhdata_34fdb73b 时间: 2022-10-21 18:40
不行,报错了
“g5.util.RTWrappedException: g5.util.RTWrappedException: java.lang.Exception: 类型转换失败导致过滤器处理失败,请检查过滤器设置。”
作者: 永洪tech-cp 时间: 2022-10-21 18:45
您的month、from、to这3列数据类型是啥?
作者: yhdata_34fdb73b 时间: 2022-10-21 19:25
都是数值类型
作者: 永洪tech-cp 时间: 2022-10-21 19:31
您用本地工具调试看下会报错吗?
作者: 永洪tech-cp 时间: 2022-10-21 19:49
我用上面这个语句试了下,不会报错,结果如下
(, 下载次数: 32)