-
-
0有了解的吗
-
0"select dp.*,db.* " + "from d_category_product dcp " + "join d_product dp on (dcp.product_id=dp.id) " + "join d_book db on (dp.id=db.id) " + "where dcp.cat_id=? limit ?,?"; 改为hql语句
-
1hql中left join fetch到底怎么用啊?比如说表A:id,name; 表B:id,info,phone。 根据id关联查这两个表
-
0select t.a,t.b ,goods.g_name ,goods.g_o_price from (select goods.g_id a,sum(sails.s_mount)b from sails, goods where sails.g_id=goods.g_id and sails.s_time<sysdate group by goods.g_id) t ,goods where t.a=goods.g_id 如何改成hql语句 sails属性 g_id fk(goods) s_mount goods属性 g_id g_name g_o_price