Every derived table must have its own alias
Every derived table must have its own alias在做多表连接查询时会出现这个错误,解决方法:每一个表都需要一个自己的别名。SELECT c.NAME,c.flow,a.flowYoY,b.flowChain from(SELECTt1.NAME,SUM( t2.flow ) AS flowFROMt_reservoir t1LEFT JOIN t_reservoir_record t2 ON t2.reservoir_code = t1.CODEWH
原创
2020-12-09 11:44:48 ·
97 阅读 ·
0 评论