“Union of ideas begets a surprising confidence” – J. Madison

Today’s post will deal with an SQL command many of us may be familiar with but may forget exists, or haven’t thought about other uses for it.

UNION

In simplest terms the UNION command allows you to join separate SQL queries into one result set. The UNION command has one optional option “ALL”