编写sql使用别名报错Invalid column name 'xxx'.
错误如下:
Select A as B from table where B = ’小明’;
修改为以下即可:
Select * from (
Select A as B from table
) as tb where B = ‘小明’
向大家推荐《Activiti工作流实战教程》:https://xiaozhuanlan.com/activiti
编写sql使用别名报错Invalid column name 'xxx'.
错误如下:
Select A as B from table where B = ’小明’;
修改为以下即可:
Select * from (
Select A as B from table
) as tb where B = ‘小明’
有建议,请留言!