Tag Archives: inner join

MySQL DELETE Join example

A very useful helper in your join toolbox can be a delete join. Even though it’s not a special join type but a join used within DELETE statements, it’s still worth mentioning. However, from time to time when I want … Continue reading

Posted in Join Tutorials | Tagged , , , | Leave a comment

Joins in MySQL 5: #1054 – Unknown column ‘…’ in ‘on clause’

If you used to write MySQL joins for MySQL versions < 5.0 or upgrade your server from MySQL 4 to MySQL >= 5.0 you maybe run into a problem when you execute the following query: SELECT * FROM mytable1, mytable2 … Continue reading

Posted in Join Hints | Tagged , , , , | 3 Comments

MySQL INNER JOIN Tutorial: the comma operator

Here you find information about writing inner joins with the comma operator. It’s the most basic way to combine (join) two tables. There is an alternative syntax that can be used, because in MySQL you can write inner joins in two … Continue reading

Posted in Join Tutorials | Tagged , , , , | 5 Comments

MySQL NATURAL JOIN Tutorial & Examples

This tutorial explains how you can use NATURAL JOINs and what a natural join is actually. Included are syntax details and example statements. Generally speaking, the keyword NATURAL can be treated as a join condition which is added implicitly. If used, it … Continue reading

Posted in Join Tutorials | Tagged , , , , | 4 Comments

MySQL STRAIGHT JOIN Tutorial & Examples

This tutorial shows you how to write straight joins in MySQL and when an it makes sense to do so. Included are a general description, syntax examples and a comparison of straight and inner joins.

Posted in Join Tutorials | Tagged , , | Leave a comment

MySQL INNER JOIN Tutorial & Examples

This tutorial shows you how to write ANSI-Style inner joins with the INNER JOIN keywords. Included are a general description, some syntax examples and a comparison between inner and cross joins. Note: In MySQL the join keywords JOIN and CROSS JOIN are … Continue reading

Posted in Join Tutorials | Tagged , , , | 48 Comments