Question

请问java和数据库高手，下面的sql如何用hibernate的hql语句来替换啊？

SELECT s.*FROM box_supplier_category s INNER JOIN (SELECT s.id AS sid, s.parent_id AS spid, s2.id AS s2id, s.is_valid FROM box_supplier_category s LEFT JOIN box_supplier_category s2 ON s2.parent_id = s.id AND s2.is_valid = 1 WHERE s2.id IS NULL AND s.is_valid = 1) t ON s.id = t.spid UNION ALL SELECT s.*FROM box_supplier_category s LEFT JOIN box_supplier_category s2 ON s2.parent_id = s.id AND s2.is_valid = 1 WHERE s2.id IS NULL AND s.is_valid = 1 AND s.parent_id IS NULL ;因为sql查询只能查询出字段，无法查出对象，请问如何用hibernate的hql语句替换呢？其中box_supplier_category 对应一个对象

Answer 1

Hql语句不支持join语句，可以使用对象的关联方式，但是太繁琐了