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