求大神帮忙解释一下这段数据库代码的意思,越详细越好,感激不尽!

select sum(chulishichang1) from formtable_main_854 t1 left join workflow_requestbase t2 on t1.requestid=t2.requestid where t2.currentnodetype =3

select sum(chulishichang1) from: 查询chulishichang1属性值的和
formtable_main_854 t1: formtable_main_854是左表,起别名为t1
left join: 左连接
workflow_requestbase t2: workflow_requestbase是右表,起别名为t2
on t1.requestid=t2.requestid: 通过这两个属性连接两张表
where t2.currentnodetype =3: 筛选条件,右表t2的currentnodetype属性值 = 3
温馨提示:答案为网友推荐,仅供参考
相似回答