oracle查询缺失关键字,queryByJoin ORA-00905: 缺失关键字 oracle异常多了一个as

queryByJoin oracle异常多了一个as

数据库版本 docker pull oracleinanutshell/oracle-xe-11g

```

SELECT

sys_user.id as id,

sys_user.dept_id as dept_id,

sys_user.login_name as login_name,

sys_user.user_name as user_name,

sys_user.password as password,

sys_user.salt as salt,

sys_user.email as email,

sys_user.phonenumber as phonenumber,

sys_user.gender as gender,

sys_user.avatar as avatar,

sys_user.status as status,

sys_user.del_flag as del_flag,

sys_user.login_ip as login_ip,

sys_user.login_date as login_date,

sys_user.create_by as create_by,

sys_user.create_time as create_time,

sys_user.update_by as update_by,

sys_user.update_time as update_time,

dept.id as dept_z_id,

dept.parent_id as dept_z_parent_id,

dept.ancestors as dept_z_ancestors,

dept.dept_name as dept_z_dept_name,

dept.order_num as dept_z_order_num,

dept.leader as dept_z_leader,

dept.phone as dept_z_phone,

dept.email as dept_z_email,

dept.status as dept_z_status,

dept.del_flag as dept_z_del_flag,

dept.create_by as dept_z_create_by,

dept.create_time as dept_z_create_time,

dept.update_by as dept_z_update_by,

dept.update_time as dept_z_update_time

FROM sys_user

LEFT JOIN

sys_dept as dept ON sys_user.dept_id = dept.id

```

SQL 无法执行

去掉sys_dept as dept 才能正常运行

```

SELECT

sys_user.id as id,

sys_user.dept_id as dept_id,

sys_user.login_name as login_name,

sys_user.user_name as user_name,

sys_user.password as password,

sys_user.salt as salt,

sys_user.email as email,

sys_user.phonenumber as phonenumber,

sys_user.gender as gender,

sys_user.avatar as avatar,

sys_user.status as status,

sys_user.del_flag as del_flag,

sys_user.login_ip as login_ip,

sys_user.login_date as login_date,

sys_user.create_by as create_by,

sys_user.create_time as create_time,

sys_user.update_by as update_by,

sys_user.update_time as update_time,

dept.id as dept_z_id,

dept.parent_id as dept_z_parent_id,

dept.ancestors as dept_z_ancestors,

dept.dept_name as dept_z_dept_name,

dept.order_num as dept_z_order_num,

dept.leader as dept_z_leader,

dept.phone as dept_z_phone,

dept.email as dept_z_email,

dept.status as dept_z_status,

dept.del_flag as dept_z_del_flag,

dept.create_by as dept_z_create_by,

dept.create_time as dept_z_create_time,

dept.update_by as dept_z_update_by,

dept.update_time as dept_z_update_time

FROM sys_user

LEFT JOIN

sys_dept dept ON sys_user.dept_id = dept.id

```