left join(左连接)、right join(右连接)、full join(全连接)、inner join(内连接)、cross join(笛卡尔积)详解

https://blog.csdn.net/qq_39072649/article/details/104551392