In this article I’ll show you how to use STRING_SPLIT() to join
You’ll find article covering several types of database joins including Inner Joins and Outer Joins.
It is important to learn about both inner and outer joins and they have different matching behavior.
I would start out with our article Introduction to Database Joins.
This first article introduces the concept of joining tables. The focus is going to be more on the type of joins, not necessarily their syntax. The later articles focus on the various types of joins. Through the narrative and examples you’ll become very comfortable with each one.
Some of our more popular articles include:
All the examples for this lesson are based on Microsoft SQL Server Management Studio and the sample databases AdventureWorks and WideWorldImporters. You can get started using these free tools using my guide Getting Started Using SQL Server
Its is easy to get confused between inner join vs outer join clauses. Both inner and outer joins are used to combine
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
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
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
SQL Joins are important to master. As you progress from a beginner to advanced beginner, you’ll soon need to combine data from
Use SQL cross joins when you wish to create a combination of every row from two tables. All row combinations are included
Use an SQL INNER JOIN when you need to match rows from two tables. Rows that match remain in the result, those
In a SQL self join the table is joined to itself. You can think of it being like an inner join. The
Many times in a relational database the information you want to show in your query is in more than one table. This
Use joins and UNIONS to combine data from two or more tables. Read this article to find out each command’s strengths and
Use both Joins and subqueries to query data from different tables. Though they may even share the same query plan, are many
In this SQL minute we’ll look at how to create a SQL server hierarchical query using the hierarchyid data type. This is
In this SQL minute we’ll look at how you can use hierarchyid to query hierarchy data. This is a two-part article. In
In this episode of SQL Minute I want to share with you how to create a pivot or cross tab chart. I’ll
I recently put together a lesson on the difference between left join versus right join operators. Outer joins are a great way
A non-equi join can be used to solve some interesting query problems. You can use a non-equi join to check for duplicate
I recently put together a lesson on table aliases and multi-table joins. You’ll find that as you write more complicated joins, that
In this puzzle, we’re going to learn how to write a SQL UNION without using Set Operations. Set operations allow us to
In this puzzle, we’re going to learn about joins vs subqueries. In many queries you can substitute joins and subqueries. Yet, since
In this puzzle, we’re going to learn how to rewrite a subquery using inner joins. Knowing about a subquery versus inner join
In this puzzle, we’re going to learn how to create a cross tab query using SQL Server. Cross tabs are a great
In this article find out how to find duplicate values in a table or view using SQL. We’ll go step by step