JPA Hibernate errors in named queries

Question

What is wrong with this NamedQuery? Did not work on Hibernate 5 but worked on Openjpa 1.2.2

 @NamedQuery(name = "Dic_listDByVal", query = "SELECT d FROM Dict d "
                + " WHERE d.memory = m.memory and d.dic = :dic and (m.value LIKE :value)"
                + " ORDER BY d.sortOrder")

Answer 1

I guess you have not defined m( in m.memory) here, meaning you must have missed a JOIN clause