/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 vote126 views1 answer
Pl/pgsql declare variable
SQL
0 vote236 views1 answer
Oracle convert int to date
SQL
0 vote115 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
1 vote108 views2 answers
Group_concat limit mysql
SQL
0 vote103 views1 answer
Json not contains mysql
SQL
0 vote109 views1 answer
Inserted row count tsql
SQL
6 votes112 views2 answers
WHERE value IS sql
SQL
1 vote124 views1 answer
Difference between where and having clause
SQL
0 vote119 views4 answers
Convert databse to achieve log mode oracle
SQL
1 vote109 views1 answer
Count mysql server db tables
SQL