/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 vote263 views1 answer
Get create table query existing table mysql
SQL
0 vote279 views4 answers
Restart MySQL
SQL
0 vote272 views1 answer
Sqlite unique multiple columns
SQL
7 votes229 views1 answer
Mysql load data infile csv
SQL
5 votes271 views1 answer
Get table columns from sql
SQL
0 vote316 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
1 vote286 views1 answer
Default
SQL
0 vote242 views1 answer
How to access to mysql without root
SQL
0 vote216 views1 answer
Flask_sqlalchemy install
SQL
0 vote263 views1 answer
How to combine first and last nae into one columb sql
SQL