sql语句update语句中嵌套的子查询该怎么写?
答案:1 悬赏:40
解决时间 2021-01-16 09:33
- 提问者网友:沉默菋噵
- 2021-01-15 23:42
sql语句update语句中嵌套的子查询该怎么写?
最佳答案
- 二级知识专家网友:煞尾
- 2021-01-16 01:14
UPDATe ccms_case_allot_count SET
org_code = BCTL.brno
,collector_name = INF.tlrno
FROM ccms_case_allot_count CO
LEFT JOIN sys_tlr_info INF ON CO.collector = inf.tlr_name
LEFT JOIN sys_bctl BCTL ON INF.brcode = BCTL.brcode
org_code = BCTL.brno
,collector_name = INF.tlrno
FROM ccms_case_allot_count CO
LEFT JOIN sys_tlr_info INF ON CO.collector = inf.tlr_name
LEFT JOIN sys_bctl BCTL ON INF.brcode = BCTL.brcode
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯