How to INNER JOIN on the same table twice in SQL statement

Having more than one INNER JOIN to the same table can be confusing. More than one INNER JOIN can create a messy SQL statement. If you don’t use aliases they can become difficult to read. So join them with aliases, as explained below. For example say you have the following two tables: Users and Products. […]

How to join the same table twice in a single SQL query statement?

Having more than one join to the same table can be confusing. You might not have even thought it was possible to have multiple joins to the same table. It is possible and easy to do with the help of aliases. Aliases for table names Aliases allow you to reference the table name with an […]

How to join three MySQL database tables together in a simple SELECT statement

Following on from my post of how to join two MySQL tables together, adding a third table is just as easy, but if you need an example this one extends the previous post by adding a third table. For example I have a table of products, table of product categories and table of product suppliers, […]