The explicit Inner Join Temporary Table

Here is the structure of our temporary table

SELECT *

FROM lifeform INNER JOIN stplanets

ON lifeform.homeworld = stplanets.planetName;

LEFT Side

RIGHT Side

Notice the Left and Right paradigm extend into the data

The Joins that use left and right are depicted here