如下查询,会抛出错误:
mysql> select sal as salary, comm as commission from emp where salary < 5000;ERROR 1054 (42S22): Unknown column 'salary' in 'where clause'
解决方案
将查询作为内联视图就...
如下查询,会抛出错误:
mysql> select sal as salary, comm as commission from emp where salary < 5000;ERROR 1054 (42S22): Unknown column 'salary' in 'where clause'
解决方案
...