bitscn.com
inner left right join语句 sql代码  create table `a` (    `a1` varchar(10) default null,    `b1` varchar(10) default null,    `c1` varchar(10) default null  ) engine=innodb default charset=utf8       create table `b` (    `a2` varchar(10) default null,    `b2` varchar(10) default null  ) engine=innodb default charset=utf8   创建出表，表内数据如下：   sql语句执行结果图片在语句的下方 sql代码  #inner join  select a.*,b.*   from a inner join b on a.a1=b.a2        sql代码  #left join  select a.*,b.*   from a left outer join b on a.a1 = b.a2    sql代码  #right join  select a.*,b.*   from a right outer join b on a.a1 = b.a2    sql代码  #full outer join union  select a.*,b.*   from a left outer join b on a.a1 = b.a2  union      select a.*,b.*   from a right outer join b on a.a1 = b.a2    sql代码  select a.*, b.* from a,b    sql代码  select a.*,b.*   from a join b on a.a1 = b.a2   默认是inner join
bitscn.com