/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

6 votes268 views5 answers
Sql add months to date
SQL
0 vote266 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote285 views1 answer
Oracle tablespace autoextend
SQL
1 vote270 views2 answers
How to search date in sql query
SQL
0 vote317 views1 answer
How to find unique element in sql
SQL
0 vote256 views1 answer
Mysql money value
SQL
0 vote255 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
3 votes280 views1 answer
Get current month last date in sql server
SQL
0 vote274 views1 answer
Ms sql filter all sympbol
SQL
4 votes263 views2 answers
Oracle default date format
SQL