Many times in a relational database the information you want to show in your query is in more than one table.  This

Read More
How do I combine results from several SQL tables (hint: there are three ways)

Use joins and UNIONS to combine data from two or more tables.  Read this article to find out each command’s strengths and

Read More
What Is the Difference Between a Join and a UNION?

The SQL UNION, SQL INTERSECT, and SQL EXCEPT clauses are used to combine or exclude like rows from two or more tables. 

Read More
SQL Union, Intersect, and Except – The Ultimate Guide

In this puzzle, we’re going to learn how to write a SQL UNION without using Set Operations.  Set operations allow us to

Read More
Full Outer Join as Union

In this puzzle, we’re going learn to about SQL set operators.  Set operators allow us to compare rows from two or more

Read More
SQL Set Operators