SQL中左关联

1.双表关联

select a.xx from 表1 a 
left join 表2 b 
on a.xx = b.xx
group by a.xx

2.多表关联

[1] 关联查询

select a.xx,b.xx,c.x
from 表1 a inner join 表2 b on a.xx = b.xx
left join 表3 c 
on a.x = c.x 

[2] 关联查询并用order by排序并计算某一字段的值

select a.xx,a.yy,b.zz,sum(c.vv) as 给新字段起个名字
from 表1 a inner join 表2 b on a.yy = b.yy
left join 表3 c 
on a.x = c.x  group by a.xx,a.yy,b.zz

等有时间了写个例子。。。