Its is easy to get confused between inner join vs outer join clauses. Both inner and outer joins are used to combine

Read More
Inner Join vs Outer Join Clauses

The SQL FULL JOIN combines results from a left and right outer join into one result.  Or in other words, it is an inner join including

Read More
SQL FULL Join

The SQL RIGHT JOIN Includes all rows from the Right table and those that match from the left.  For that doesn’t match from the right, NULL is returned in the

Read More
SQL Right Join

The SQL LEFT JOIN Includes all rows from the left table and those that match from the right table. When the right table doesn’t match the

Read More
SQL Left Join

SQL Joins are important to master. As you progress from a beginner to advanced beginner, you’ll soon need to combine data from

Read More
SQL Joins – The Ultimate Guide

Use SQL cross joins when you wish to create a combination of every row from two tables.  All row combinations are included

Read More
SQL Cross Join

Use an SQL INNER JOIN when you need to match rows from two tables.  Rows that match remain in the result, those

Read More
SQL Inner Join

In a SQL self join the table is joined to itself.  You can think of it being like an inner join. The

Read More
SQL Self Join

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?

Use both Joins and subqueries to query data from different tables. Though they may even share the same query plan, are many

Read More
Subqueries versus Joins

In this SQL minute we’ll look at how to create a SQL server hierarchical query using the hierarchyid data type.  This is

Read More
SQL Server Hierarchical Query using the hierarchyid type

In this SQL minute we’ll look at how you can use hierarchyid to query hierarchy data.  This is a two-part article.  In

Read More
Use hierarchyid to query Hierarchical data

In this episode of SQL Minute I want to share with you how to create a pivot or cross tab chart. I’ll

Read More
SQL Pivot Table – Learn to Create in Six Steps

I recently put together a lesson on the difference between left join versus right join operators.  Outer joins are a great way

Read More
Left Join versus Right Join Comparison

A non-equi join can be used to solve some interesting query problems. You can use a non-equi join to check for duplicate

Read More
What is a Non-Equi Join in SQL and What is its Purpose?

I recently put together a lesson on  table aliases and multi-table joins.  You’ll find that as you write more complicated joins, that

Read More
How to Make a Join Easier to Read using Table Aliases

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 to learn about joins vs subqueries.  In many queries you can substitute joins and subqueries.  Yet, since

Read More
Joins vs Subqueries SQL Puzzle

In this puzzle, we’re going to learn how to rewrite a subquery using inner joins.  Knowing about a subquery versus inner join

Read More
Rewrite Subquery as a Join

In this puzzle, we’re going to learn how to create a cross tab query using SQL Server.  Cross tabs are a great

Read More
Use SQL Server to Create a Cross Tab Query

In this article find out how to find duplicate values in a table or view using SQL.  We’ll go step by step

Read More
How can I find Duplicate Values in SQL Server?