Inner Join Tables

-- Create table called adventurers
CREATE TABLE adventurers (
    -- string variable
    name varchar(255),
    -- integer variable
    age int,
    -- string variable
    race varchar(255)
)

-- Create table called equipment
CREATE TABLE equipment (
    -- string variable
    name varchar(255),
    -- string variable
    clothes varchar(255),
    -- string variable
    weapon varchar(255)
)

INSERT INTO adventurers (name, age, race)
VALUES ('Dallar Woodfoot', 25, 'Elf'),
       ('Cordin Garner', 29, 'Elf'),
       ('Keat Knigh', 24, 'Dwarf'),
       ('Colbat Nalor', 124, 'Dwarf')

INSERT INTO equipment (name, clothes, weapon)
VALUES ('Dallar Woodfoot', 'Leather Armor', 'Axe'),
       ('Keat Knigh', 'Robe', 'Bow'),
       ('Cordin Garner', 'Tunic', 'Axe'),
       ('Colbat Nalor','Chainmail', 'Axe')

-- Return the name of people from the adventurers table, age, race, clothes, and weapon
SELECT adventurers.name, age, race, clothes, weapon FROM adventurers
-- Inner join with the equipment table
INNER JOIN equipment
    -- Using the adventurers name as the merge key
    ON (adventurers.name = equipment.name)