TheAxeRant.com

We usually use join to find the intersection between two different tables.  For example, if you want all of the orders from the order table who belong to a certain set of customers from the customer table.

This is the most common usage of a join, specifically an inner join.  The results only include the entries that match up from each table.  There are many other situations that you can incorporate a JOIN to solve.  Particularly here we are going to talk about using a JOIN to suppress information from one table by using another. (more…)

The PIVOT  function can be a very powerful one for transforming data.  The very basics are this, PIVOT allows you to take a tall schema table and transform it into a wide schema table. (more…)