/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 vote271 views1 answer
Heidisql check how much space a row
SQL
0 vote268 views1 answer
We are intrested to work with your organization
SQL
0 vote283 views1 answer
Difference between min and max date sql
SQL
0 vote281 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
10 votes262 views1 answer
How to import database in mysql by cmd
SQL
0 vote296 views1 answer
Exit psql
SQL
7 votes285 views2 answers
Oracle sql drop index
SQL
5 votes290 views3 answers
Mysql remove unique constraint
SQL
23 votes278 views4 answers
Sql server substring
SQL
0 vote360 views1 answer
How to rename a database in tsql
SQL