/SQL/Implicit inner join table alias with id values

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;

Source: lambdaschool.instructure.com

Similar codes

1 vote209 views1 answer
Mysql select all and rename one
SQL
0 vote193 views1 answer
Mysql error 1251
SQL
0 vote181 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote171 views1 answer
Oracle locked objects
SQL
1 vote175 views1 answer
Postgres get timestamp
SQL
8 votes190 views4 answers
How to calculate the age from date of birth in python
SQL
21 votes244 views6 answers
Update sql
SQL
2 votes179 views4 answers
Check timezone of mysql database
SQL
1 vote191 views1 answer
How to truncate a table in databse
SQL
0 vote208 views1 answer
Sqlite version check
SQL