本文介绍了三种不同的SQL查询方法，包括左连接与分组查询的应用场景和技术细节。通过对具体SQL语句的解析，帮助读者理解如何有效地从不同数据表中提取所需信息。
select x.id as id,x.siteName as siteId,s.site_name as siteName,x.flg as flg ,x.product as pt
from xj_inf x left join site1 s on x.siteName = s.site_id
group by x.id ,x.siteName ,s.site_name , x.flg, x.product
select x.id as id,x.siteName as siteId,s.site_name as siteName,x.flg as flg ,x.product as pt
from xj_inf x left join site1 s on x.siteName = s.site_id group by siteName,pt,flg
select x.id as id,x.siteName as siteId,s.site_name as siteName,x.flg as flg ,x.product as pt
from xj_inf x , site1 s where x.siteName = s.site_id group by siteName,pt,flg
from xj_inf x left join site1 s on x.siteName = s.site_id
group by x.id ,x.siteName ,s.site_name , x.flg, x.product
select x.id as id,x.siteName as siteId,s.site_name as siteName,x.flg as flg ,x.product as pt
from xj_inf x left join site1 s on x.siteName = s.site_id group by siteName,pt,flg
select x.id as id,x.siteName as siteId,s.site_name as siteName,x.flg as flg ,x.product as pt
from xj_inf x , site1 s where x.siteName = s.site_id group by siteName,pt,flg
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
