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;

因篇幅问题不能全部显示，请点此查看更多更全内容

查看全文