0
Why this is not working
INSERT INTO Animals(name, type, country_id) VALUES('slim', 'Girafee', 1); SELECT Animals.name, Animals.type, countries.country From Animals INNER JOIN countries ON Animals.country_id = Countries.id ORDER BY country;
1 Answer
+ 2
-- 28 Code project "Giraffe"
insert into Animals (name, type, country_id)
values ('Slim', 'Giraffe', 1);
select a.name, a.type, c.country
from Animals a
inner join Countries c on c.id=a.country_id
order by c.country;