implicit inner join table alias with id values 1

implicit inner join table alias with id values

SELECT character.name, item.name
FROM charactercreator_character AS character,
charactercreator_character_inventory AS inventory,
armory_item AS item
WHERE character.character_id = inventory.character_id
AND inventory.item_id = item.item_id
LIMIT 10;

Here is what the above code is Doing:
1. We’re selecting the name of the character and the name of the item.
2. We’re selecting from the charactercreator_character table as character, the charactercreator_character_inventory table as inventory, and the armory_item table as item.
3. We’re matching the character_id in the character table to the character_id in the inventory table.
4. We’re matching the item_id in the inventory table to the item_id in the item table.
5. We’re limiting the results to 10.

Similar Posts