mysql implements table connection (left, right, inner, full join)
The connection between two tables appears in the query. The following uses examples to explain the differences between various connection queries
Table a, and table b are as shown below
a has abcd in the table
in the table 
SELECT * from a INNER JOIN b on a.name=b.id;
SELECT * from a left JOIN b on a.name=b.id;
SELECT * from a right JOIN b on a.name=b.id;
(SELECT * from a left JOIN b on a.name=b.id) UNION (SELECT * from a RIGHT JOIN b on a.name=b.id );
//m.sbmmt.com/course/list/51.html
The above is the detailed content of About mysql implementation of table join (left, right, inner, full join). For more information, please follow other related articles on the PHP Chinese website!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
