implicit inner join table alias with id values

1SELECT character.name, item.name
2FROM charactercreator_character AS character,
3charactercreator_character_inventory AS inventory,
4armory_item AS item
5WHERE character.character_id = inventory.character_id
6AND inventory.item_id = item.item_id
7LIMIT 10;