SELECT * FROM
(SELECT * FROM DateRecords c LEFT JOIN
(SELECT DATE_FORMAT(usetime,'%Y-%m-%d') cdate,SUM(price) pricesum,SUM(POINT) pointsum FROM game_ecard GROUP BY DATE_FORMAT(usetime,'%Y-%m-%d')) a
ON c.statday=a.cdate ) d
LEFT JOIN
(SELECT DATE_FORMAT(crtime,'%Y-%m-%d') cdate ,SUM(gamepiont) gamepiontsum FROM game_money GROUP BY DATE_FORMAT(crtime,'%Y-%m-%d')) b
ON d.statday=b.cdate;怎样把上面的SQL转换为HQL语句,
各位大虾,,,指点指点啊..
(SELECT * FROM DateRecords c LEFT JOIN
(SELECT DATE_FORMAT(usetime,'%Y-%m-%d') cdate,SUM(price) pricesum,SUM(POINT) pointsum FROM game_ecard GROUP BY DATE_FORMAT(usetime,'%Y-%m-%d')) a
ON c.statday=a.cdate ) d
LEFT JOIN
(SELECT DATE_FORMAT(crtime,'%Y-%m-%d') cdate ,SUM(gamepiont) gamepiontsum FROM game_money GROUP BY DATE_FORMAT(crtime,'%Y-%m-%d')) b
ON d.statday=b.cdate;怎样把上面的SQL转换为HQL语句,
各位大虾,,,指点指点啊..
这专程hql语句了 效率估计很低的
就用Hibernate执行原生SQL语句