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)

SQL ANY and ALL keywords are used in subquery comparisons to compare a set of value against all values in the result

Read More
SQL ANY and ALL Operators

The SQL In operator compare a column to a list. In this article we’ll see how to use In and NOT IN

Read More
SQL In Operator

A derived table is a subquery in the from clause.  It returns a table as its result.  Unlike other subqueries you name

Read More
Derived Tables

Correlated subqueries are used to tie an inner query’s criteria to values within the outer query. They are powerful technique to avoid

Read More
Correlated Subqueries in SQL

In this puzzle we’ll explore a SQL bill of materials example. Companies use a BOM (Bill of Materials) to itemize the components

Read More
SQL Bill of Materials Example

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

SQL subqueries make it possible for you to write queries that are more dynamic, and data driven. Think of them as query within another

Read More
SQL Subqueries – The Ultimate Guide

In this video we’ll walk you though how to use the IN operator with a Subquery; we’ll show you why you would

Read More
How to use the IN Operator with a SubQuery

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

The SQL EXISTS operator is mostly used to test whether a subquery returns rows. It returns TRUE if rows exists in the

Read More
Using WHERE EXISTS in SQL