Help! why it doesn't work? SQL, "Zoo""quiz. | Sololearn: Learn to code for FREE!

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;

2/8/2021 6:22:22 PM

Ling

4 Answers

New Answer

+1

Ling INNER JOIN Countries ON Animals.country_id = Countries.id ORDER BY country ;

+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.

0

prefix name, type, and country with the tables they belong to: SELECT Animals.name, Animals.type, Countries.country FROM ...

0

Thanks. with or without Animals. name, it works. I use Order by country, but error. I try again.