/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 vote236 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote177 views1 answer
How to drop columns with constraint from a table in sql script
SQL
8 votes180 views1 answer
Insert a select statement into a table
SQL
0 vote188 views2 answers
Uninstall postgresql mac
SQL
0 vote192 views1 answer
How to move a column to different spot mysql
SQL
9 votes202 views6 answers
Oracle substring
SQL
0 vote172 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote169 views1 answer
Selects all the columns from the sailors table
SQL
0 vote180 views3 answers
Sql delete all except
SQL
0 vote181 views2 answers
Sql drop view if exists
SQL