Question

sql语句在mysql中可以查到数据，但在代码中查询不到数据？？？

代码：
String selectSql = "select personInfo.fd_id personInfoId,personInfo.fd_staff_no fdStaffNo,welfare.fd_id welfareId " +
"from hr_staff_person_info personInfo " +
"left join hr_staff_emolument_welfare welfare " +
"on personInfo.fd_id = welfare.fd_person_info_id " +
"where personInfo.fd_id not in (select fd_id from rqss_salary_main)";
List<Object[]> list = session.createSQLQuery(selectSql).list();

Answer 1

你的sql语句为什么要拼接？直接整段完整的就好