What is the join in the sql statement

What is the join in the sql sentence? I believe many inexperienced people don't know what to do about it. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Left join (left join) returns records that include all records in the left table and records that are equal to join fields in the right table

Right join (right join) returns records that include all records in the right table and records that are equal to join fields in the left table

Inner join (equivalent join) returns only rows with equal join fields in two tables.

After reading the above, have you mastered the method of what join is in the sql statement? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!