Full syntax inner join

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

0 vote122 views1 answer
Sql server order by nulls last
SQL
13 votes168 views6 answers
Mysql remove duplicates
SQL
7 votes131 views1 answer
Buy forge mods server hosting
SQL
2 votes87 views1 answer
Foreign key example in dbms
SQL
5 votes124 views1 answer
How to get all dates in a month in oracle
SQL
1 vote124 views1 answer
Database Queries
SQL
0 vote136 views1 answer
No suitable driver found for sqlite
SQL
0 vote133 views1 answer
Get date from timestamp in mysql
SQL
1 vote226 views1 answer
Mysql data from file
SQL
1 vote130 views1 answer
Show per page table in xampp
SQL