syntax error at or near “from“

syntax error at or near “from“"/>

syntax error at or near “from“

前言

syntax error at or near "from"

select a_id aid,a.params,a.c_date cdate , m.nickname  operator from activity  a
left join manager m on a.operator=m.openid
order by  a.c_date desc;

问题

operator是activity里边的字段 想用左查询的字段替换掉，这样写法报错

解决

正确写法加as 习惯性不写出错了 😃

select a_id aid,a.params,a.c_date cdate , m.nickname as operator from activity  a
left join manager m on a.operator=m.openid
order by  a.c_date desc;