A code is worth a thousand words

MySQL Joins - Visual Representation

You are here

Full guide for MySQL joins. Visual data and query examples should make the subject perfectly clear or you can bookmark it as a good reference. So here it is, the visual representation of sql (mysql) joins.

What are joins in MySQL?
Joins in SQL are fore combining records from two or more tables in a database. Join mean combining values from two tables using a common value, usual common identifier (ID) is used. Relational systems commonly call for joins, the key is efficient implementation of joins. You might want to follow up on indexing tables.

Equi-Join, Join and Inner Join

Inner shows only rows that share a common value in both tables.
All of these three queries produce the same result. Equi-Join is the easiest way of using join. It doesn't require any join, you just select multiple tables and use where statement to define the common part. Join is same as inner join, basically join defaults to inner join.