0

Help! why it doesn't work? SQL, "Zoo""quiz.

/* name - "Slim", type - "Giraffe", country_id - 1 */ INSERT INTO animals VALUES ('Slim','Giraffe', 1); SELECT name,type,country FROM Animals INNER JOIN Countries ON Animals.country_id=Countries.id;

8th Feb 2021, 6:22 PM
Ling
Ling - avatar
4 Answers
+ 1
Ling INNER JOIN Countries ON Animals.country_id = Countries.id ORDER BY country ;
8th Feb 2021, 8:22 PM
**🇦🇪|🇦🇪**
**🇦🇪|🇦🇪** - avatar
+ 1
Thanks Wedad Saleh, I put ; in front of Order by country, so it doesn't work. Now it works. Thanks again. And thanks John Robotane too.
8th Feb 2021, 9:39 PM
Ling
Ling - avatar
0
prefix name, type, and country with the tables they belong to: SELECT Animals.name, Animals.type, Countries.country FROM ...
8th Feb 2021, 7:09 PM
John Robotane
John Robotane - avatar
0
Thanks. with or without Animals. name, it works. I use Order by country, but error. I try again.
8th Feb 2021, 9:26 PM
Ling
Ling - avatar