View's SELECT contains a subquery in the FROM clause
MySQL不支持子查询,解决办法就是把子查询分成多个视图,然后再把其它视图当表一样关联查询
-- 人员视图
CREATEORREPLACEVIEW view_pem_emp ASSELECT se.user_no,se.emp_name,se.dept_no from sys_employee as se WHERE se.tenants_no = 5AND emp_status = 2;-- 部门视图CREATEORREPLACEVIEW view_pem_dept ASSELECT sd.id AS dept_no,sd.dept_name,sd.parent_id from sys_department as sd WHERE sd.tenants_no = 5AND is_enable = 1;-- 订单按员工统计视图CREATEORREPLACEVIEW view_pem_sales_emp ASSELECT ps.user_no,SUM(ps.buy_amount)