/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 vote356 views1 answer
Migrations.RunSQL
SQL
3 votes405 views6 answers
DB::table('users')->get();
SQL
1 vote356 views4 answers
Sequelize migration default value
SQL
0 vote339 views1 answer
Sql server remove 0 from left
SQL
0 vote331 views1 answer
Python mysql query where
SQL
2 votes373 views1 answer
Find all triggers in database
SQL
0 vote365 views2 answers
Mysql decimal remove trailing zeros
SQL
8 votes386 views1 answer
Oracle search stored procedures for text
SQL
2 votes433 views5 answers
Tablespace ORACLE
SQL
1 vote367 views2 answers
Get table column names sql laravel
SQL