JOIN issues

Databases
3

So why don’t you debug step by step?

What happens if you only select

`SELECT * FROM countries WHERE countries.country_id = 1;`

If the result is correct then try

SELECT * FROM countries 
INNER JOIN states ON states.country_id = countries.country_id
WHERE countries.country_id = 1;

and so on…