/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 vote145 views1 answer
How to find database collation in postgres
SQL
0 vote153 views1 answer
Error code 1451 sql
SQL
11 votes137 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote148 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote151 views1 answer
Sql sum show 0 result
SQL
0 vote168 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote146 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote125 views1 answer
Materialized view redshift
SQL
0 vote148 views1 answer
Mysql update set sum
SQL
1 vote177 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL