如题
select log.id, log.desc, IFNULL(user.username, del_user.username) as username
from logs log
left join user on (log.userid= user.userid)
left join del_user on (del_user.userid= log.userid);
上面的sql语句用到了 IFNULL 请问hql有相似的函数吗 数据库是mysql在线等....
select log.id, log.desc, IFNULL(user.username, del_user.username) as username
from logs log
left join user on (log.userid= user.userid)
left join del_user on (del_user.userid= log.userid);
上面的sql语句用到了 IFNULL 请问hql有相似的函数吗 数据库是mysql在线等....
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货