/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 vote164 views1 answer
Pl sql turn off variable substitution
SQL
0 vote186 views1 answer
Get initials name in sql
SQL
0 vote164 views1 answer
How to insert same table data using mysql query
SQL
0 vote193 views1 answer
How to find date from date table in sql
SQL
2 votes201 views2 answers
How to run postgresql in linux
SQL
0 vote175 views2 answers
Mysql select date from datetime
SQL
8 votes181 views1 answer
Show mysql user table
SQL
8 votes134 views8 answers
Second highest salary in mysql
SQL
39 votes184 views4 answers
Select duplicates in sql
SQL
0 vote148 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL