1、交叉连接(即笛卡尔积 两个表相乘)
2、内连接

3、外连接
3.1左外连接

3.2右连接<??http://www.2cto.com/kf/ware/vc/" target="_blank" class="keylink">vcD4KPHA+PGltZyBzcmM9"https://www.cppentry.com/upload_files/article/57/1_eh15z__.png" alt="\">
3.3自连接(两张相同的表连接)

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
子查询

