求高手帮我把这条sql翻译成Ksql,谢谢!!!
993次浏览
编辑于2014年08月16日 13:56:53
这是sqlserver关联表更新,现在想改成ksql,求高手帮忙:
UPDATE TPT_FZC_GOODSMSGENTRY SET FFINISHDATE = T1.FFINISHDATE, FSUMMARY = T1.FSUMMARY
FROM TPT_FZC_INSPECTCONSOLEENTRY T1
WHERE TPT_FZC_GOODSMSGENTRY.FID = T1.FID AND TPT_FZC_GOODSMSGENTRY.FGOODSID = T1.FGOODSID AND T1.FID = '{0}'
UPDATE TPT_FZC_GOODSMSGENTRY SET FFINISHDATE = T1.FFINISHDATE, FSUMMARY = T1.FSUMMARY
FROM TPT_FZC_INSPECTCONSOLEENTRY T1
WHERE TPT_FZC_GOODSMSGENTRY.FID = T1.FID AND TPT_FZC_GOODSMSGENTRY.FGOODSID = T1.FGOODSID AND T1.FID = '{0}'
推荐阅读
您的鼓励与嘉奖将成为创作者们前进的动力,如果觉得本文还不错,可以给予作者创作打赏哦!
请选择打赏金币数 *
10金币20金币30金币40金币50金币60金币
可用金币: 0