1.关联语句inner join on 和 left join on的区别
inner join on相当于以下语句
select a.*,b.* from user a ,UserChannel b where a.UserID=B.UserID
即和
select a.*,b.* from user a inner join UserChannel b on a.userid=b.UserID
结果一致;
但left join on的作用在于,当a.Userid在b.UserID中不存在时,那么b.UserID显示为空,
避免了记录丢失,而且统计的数量和select a.* from User的数量相等;
select a.*,b.* from User A,UserChannel B left join on a.userid=b.userid