A Venn diagram representing the full join SQL statement between tables A and B. A join clause in the Structured Query Language (SQL) combines columns from one or more tables into a new table. The operation corresponds to a join operation in relational algebra. Informally, a join stitches two tables and puts on the same row records with matching fields : INNER, LEFT OUTER, RIGHT OUTER, FULL OUTER a
![Join (SQL) - Wikipedia](https://cdn-ak-scissors.b.st-hatena.com/image/square/76bd3291fc34291702ebc62c7f9605271fed6708/height=288;version=1;width=512/https%3A%2F%2Fupload.wikimedia.org%2Fwikipedia%2Fcommons%2Fd%2Fd2%2FSquare_join.png)