Question

关于HQL不支持from子查询

请教各位大虾，这句话改成HQL怎么改？据说HQL不支持from的子查询

select a.*,p.* from(select * from supplypro where sid = 1) a right join product p on a.pid = p.pid order by a.no desc;

Answer 1

select a.*,p.* from supplypro a right join product p on a.pid = p.pid where a.sid = 1 order by a.no desc;
试试看。

Answer 2

你有木有配关系，有的话可以直接导航，不过尸体要new出来，不然是导航不出来滴，