sql
[quote]
内连接
含有评论的twitter
select ctw.twitter_id,ctw.twitter_content ,count(cco.coment_id) from ct_twitter ctw ,ct_comment cco where ctw.twitter_id = cco.twitter_id group by ctw.twitter_id,ctw.twitter_content
[color=red][size=large]/[/size][/color]
select ctw.twitter_id,ctw.twitter_content ,count(cco.coment_id) from ct_twitter ctw inner join ct_comment cco on ctw.twitter_id = cco.twitter_id group by ctw.twitter_id,ctw.twitter_content
左连接
所有twitter
select ctw.twitter_id,ctw.twitter_content ,count(cco.coment_id) from ct_twitter ctw left join ct_comment cco on ctw.twitter_id = cco.twitter_id group by ctw.twitter_id,ctw.twitter_content
右连接
[/quote]
[quote]
内连接
含有评论的twitter
select ctw.twitter_id,ctw.twitter_content ,count(cco.coment_id) from ct_twitter ctw ,ct_comment cco where ctw.twitter_id = cco.twitter_id group by ctw.twitter_id,ctw.twitter_content
[color=red][size=large]/[/size][/color]
select ctw.twitter_id,ctw.twitter_content ,count(cco.coment_id) from ct_twitter ctw inner join ct_comment cco on ctw.twitter_id = cco.twitter_id group by ctw.twitter_id,ctw.twitter_content
左连接
所有twitter
select ctw.twitter_id,ctw.twitter_content ,count(cco.coment_id) from ct_twitter ctw left join ct_comment cco on ctw.twitter_id = cco.twitter_id group by ctw.twitter_id,ctw.twitter_content
右连接
[/quote]
select cde.dept_id count(cus.user_id),count(cve,vest_id) from ct_dept cde left join ct_user cus on cde.dept_id = cus.dept_id
待续....