O'Reilly logo

MySQL for Python by Albert Lukaszewski, PhD

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Joins

Joins are often one of the hardest topics for MySQL newcomers to grasp. The entire concept pivots on the understanding of mathematical sets, unions, intersections, and their resulting Venn diagrams. Another way of looking at joins is to use tabular information. For an example of this, see: http://en.wikipedia.org/wiki/Sql_join.

Joins

In the preceding Venn diagram, the left circle may be seen to represent one set and the right circle another. The overlapping area is called the intersection of the two sets. The set of elements that encompasses the contents of both circles is called a union, but should not be confused with the MySQL keyword UNION

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required