2019獨角獸企業(yè)重金招聘Python工程師標(biāo)準(zhǔn)>>>

SELECT u.*,count(u.id) AS sum FROM user AS uLEFT JOIN post AS pON p.user_id = u.id RIGHT JOIN user_has_group as upON up.user_id = u.id RIGHT JOIN user_has_email as ueON ue.user_id = u.idWHERE u.username != ''AND up.group_id = {$args['groupid']}AND ue.email = '{$args['useremail']}'GROUP BY u.id ORDER BY u.id desc

轉(zhuǎn)載于:https://my.oschina.net/zhangdapeng89/blog/40404

總結(jié)

以上是生活随笔為你收集整理的mysql---复杂的sql语句join的使用（left join,right join）的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。