/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

0 vote151 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
3 votes72 views1 answer
System.debug apex
SQL
1 vote111 views1 answer
Customer using hdfc bank sql query
SQL
0 vote129 views1 answer
Except in sql alchemy
SQL
18 votes115 views4 answers
Mysql current date between two dates
SQL
0 vote109 views1 answer
Using GROUP BY in MySQL Join Table
SQL
5 votes119 views2 answers
Sql server port number
SQL
1 vote119 views1 answer
Mysql list bigger table
SQL
0 vote129 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
11 votes119 views1 answer
Oracle view source
SQL