Category Archives: Join Hints

MySQL Outer Join: ON vs. WHERE condition

www.avtokum.com/ uniti.ua

Posted in Join Hints | Leave a comment

In depth explanation of SQL join types

While we at mysqljoin.com want to provide simply and straightforward tutorials which are easy to understand, we love in depth documentation as well. And since relational databases are very complex, a documentation can be much more technical than our tutorials … Continue reading

Posted in Join Hints | Leave a comment

A visualisation of SQL Joins

Generally speaking, every result set that is created by a join is a certain combination of rows which are stored in MySQL tables. Even if you join more than two tables, MySQL always combines two result sets at a time. These … Continue reading

Posted in Join Hints | 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