我有我正在執行的 hql 查詢，但收到一個我不太了解原因的錯誤。這是我的代碼：@Overridepublic List<StaffRequest> getStaffLeaveRequest(String userID, Date startDate, Date endDate) {    Session currentSession = sessionFactory.getCurrentSession();            List<StaffRequest> results =     currentSession.createQuery("select new com.timesheet_Webservice.CustomEntity.StaffRequest(lr.leave_ID, lr.leave_Employee, concat(s.staff_First_Name, ' ', s.staff_Last_Name), "            + "(lr.leave_Days*8.5), lr.leave_Comments, '1805', concat(pro.project_Pastel_Prefix, ' - ', pro.project_Description), lr.leave_Start, lr.leave_End, lr.leave_IsApproved, "            + "(select lt.leaveType_Description from LeaveType lt where lt.leaveType_ID = lr.leave_Type)) "            + "from Staff s, Project pro, Leave lr "            + "where lr.leave_Employee = s.staff_Code and pro.project_Code = 1805 and lr.leave_Approved = :userID and lr.leave_IsApproved = 0 and s.staff_IsEmployee <> 0 "            + "and lr.leave_Start between :startDate and :endDate "            + "order by concat(s.staff_First_Name, ' ', s.staff_Last_Name)")            .setParameter("userID",userID).setParameter("startDate", startDate).setParameter("endDate", endDate).getResultList();       return results;}嘗試執行時，我在網頁上收到此錯誤：org.hibernate.exception.SQLGrammarException：無法提取 ResultSet還有這個控制臺錯誤：錯誤：您的 SQL 語法有錯誤；檢查與您的 MariaDB 服務器版本相對應的手冊，以在第 1 行的“離開 leave2_ where leave2_.Leave_Employee=staff0_.Staff_Code and project1_.Proj”附近使用正確的語法這似乎表明 where 子句有一些錯誤，但我沒有看到任何特別錯誤的地方。更新： 實體類項目@Entity@Table(name="project")public class Project {    @Id    @GeneratedValue(strategy=GenerationType.IDENTITY)    @Column(name="Project_Code")    public int project_Code;    @Column(name="Project_Customer")    public int project_Customer;    //A lot more attributes...}職員@Entity@Table(name="staff")public class Staff {    @Id    @Column(name="Staff_Code")    public String staff_Code;    ...}