String hql = "select * from shop where shop.strid in(select strid from moneythreeshop where moneythreeshop.strid = shop.strid)";
Query query=session.createSQLQuery(hql).addEntity(Shop.class);
如果还要得到对应的类 就家 addEntity 注意只有部分字段是不可行的
String hql = "select * from shop where shop.strid in(select strid from moneythreeshop where moneythreeshop.strid = shop.strid)";
Query query=session.createSQLQuery(hql).addEntity(Shop.class);