sql left join

最新推荐文章于 2023-02-22 11:54:22 发布

iteye_19532

最新推荐文章于 2023-02-22 11:54:22 发布

阅读量111

点赞数

本文链接：https://blog.csdn.net/iteye_19532/article/details/82640479

版权

select *,sum(sri.RI_REQUIREMENT_OFFER_MONEY),count(str.UR_SEQ) ,avg(sue.UE_EVALUATE_SCORE)
from SFRLF_TEAM_INFO sti

left outer join SFRLF_TEAM_REQUIREMENT str

on str.UR_TEAM_ID=sti.TN_TEAM_ID

and str.UR_STATUS='0'

left outer join SFRLF_USER_EVALUATE sue

on sue.UE_TEAM_ID=sti.TN_TEAM_ID

and sue.UE_REQ_ID=str.UR_REQ_ID

left outer join SFRLF_REQUIREMENT_INFO sri

on sri.RI_REQUIREMENT_ID=str.UR_REQ_ID

group by TN_TEAM_ID

having sti.TN_TEAM_NAME like '中文'

order by avg(sue.UE_EVALUATE_SCORE) desc

limit 0,21