欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

复杂的sql语句join的使用(left join,right join)_MySQL

程序员文章站 2022-05-24 16:04:50
...
bitsCN.com SELECT u.*,count(u.id) AS sum
02
FROM user AS u
03
LEFT JOIN post AS p
04
ON p.user_id = u.id
05
RIGHT JOIN user_has_group as up
06
ON up.user_id = u.id
07
RIGHT JOIN user_has_email as ue
08
ON ue.user_id = u.id
09
WHERE u.username != ''
10
AND up.group_id = {$args['groupid']}
11
AND ue.email = '{$args['useremail']}'
12
GROUP BY u.id ORDER BY u.id desc bitsCN.com
相关标签: sql语句 count