内连接查询:from table1 inner join table2
外连接查询:左外连接查询: from table1 left outer join table2
左外连接查询: from table1 right outer join table2
内连接查询:from table1 inner join table2
外连接查询:左外连接查询: from table1 left outer join table2
左外连接查询: from table1 right outer join table2