如何在Criteria中编写子查询

I have a SQL like this:

我有这样的SQL：

Select tbl.id, tbl.name 
From 
 (select table1.id, table1.name
 from table1
 inner join table2 on table1.id = table2.id
 order by table2.priority
 ) tbl 
group by table1.id
order by table1.name
Select tb