OUTER JOIN Tag Archives

Learn How to Combine Data with a CROSS JOIN

Cross Join Meme

A cross join is used when you wish to create combination of every row from two tables.  All row combinations are included in the result; this is commonly called cross product join.  A common use for a cross join is to create obtain all combinations of items, such as colors and sizes. Note:  The series […]

Continue reading
4

What is the Difference between Inner and Outer Joins?

Both inner and outer joins can be used to combine data from two or more tables; however, there are some key differences!  Read this article to find out each command’s strengths and when to use them. To get the most of this and our other lessons be sure to practice using the examples! All the […]

Continue reading
6

SQL Join – Introduction to Inner, Outer, and Cross Joins

SQL Joins are important to master. As you progress from a beginner to advance beginner, you’ll soon need to combine data from more than one table. To do this, you’ll use database joins.  In this series of articles I’ll show you how to write a query that combines, or joins, data from more than one […]

Continue reading
>