Dissecting The explicit Inner Join

Let’s look at this Example in More Detail

SELECT

lifeformName AS Race,

planetName AS Home,

planetClass AS Class

FROM lifeform INNER JOIN stplanets

ON lifeform.homeworld = stplanets.planetName;

LEFT Side

RIGHT Side

Several of the join types will refer to “Left” and “Right”, this is what they are referring to

Internally this command has created a temporary table which contains all the fields from both source tables

Let’s prove what our temporary table looks like with a SELECT *