Implicit inner join table alias

SELECT character.name, inventory.id
FROM charactercreator_character AS character,
charactercreator_character_inventory AS inventory
WHERE character.character_id = inventory.character_id;

Source: lambdaschool.instructure.com

Similar codes

8 votes146 views1 answer
Oracle find text in functions
SQL
0 vote101 views1 answer
Ms sql print more than 1 variable
SQL
0 vote158 views1 answer
How to display value of variable in mysql
SQL
0 vote139 views1 answer
Where case insensitive like mysql
SQL
0 vote144 views1 answer
VSCode SQL Server Connection error
SQL
1 vote180 views1 answer
Wordpress change url phpmyadmin
SQL
0 vote184 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote146 views2 answers
Oracle create chain rule
SQL
17 votes169 views3 answers
Postgresql list users
SQL
0 vote144 views1 answer
Postgresql parse json array
SQL