/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 vote150 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote167 views1 answer
How to update date value in sql
SQL
3 votes197 views2 answers
How to View column names of a table in SQL
SQL
4 votes147 views1 answer
Sql delete where in select
SQL
0 vote180 views1 answer
Mysql bind-address default value
SQL
0 vote112 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote145 views1 answer
How to move a columns location in mysql
SQL
0 vote102 views1 answer
Sql query with date
SQL
5 votes144 views2 answers
Oracle to_timestamp
SQL
5 votes171 views2 answers
Get columns number sql
SQL