服务层SQL查询时错误汇总

一、HQL多表查询语句报ORA-00907缺失右括号

SQL语句：

select s.sys_id,s.corp_id,s.sys_name,c.corp_name
				from t_sc_info_sys s,t_sc_info_corp c
				where s.corp_id = c.corp_id

错误原因：略

解决方法：将表名和字段名改为大写

select s.SYS_ID,s.CORP_ID,s.SYS_NAME,c.CORP_NAME 
				from T_SC_INFO_SYS s,T_SC_INFO_CORP c 
				where s.CORP_ID = c.CORP_ID