java 实现 sql join_7种SQL Join语句

1、SQL语句结构

select  distinct  < select_list >

from  < left_table > < join_type >

join  < right_table >

on  < join_condition >

where  < where_condition >

group by  < group_by_list >

having  < having_condition >

order by  < order_by_condition >

limit  < limit_number >

2、7种Join方式及实例

实验脚本：

drop table IF EXISTS shuzi ;

create table shuzi (id tinyint,note varchar(20));

insert into shuzi values (1,'一'),(2,'二'),(3,'三'),(4,'四'),(5,'五'),(6,'六'),(7,'七'),(8,'八'),(9,'九'),(10,'十');

select * from shuzi;

drop table IF EXISTS qianshu ;

create table qianshu (id int,des varchar(20));

insert into qianshu values (1,'壹'),(2,'贰'),(4,'肆'),(5,'伍&#