+ 1
Zoo problem is sql
I think my query is right but sololearn shows error in from clause missing my query has from clause insert into animals values('slim','Giraffe',1); SELECT animals.name,animals.type,animals.country_id,countries.country,countries.id FROM animals,countries WHERE animals.country_id=countries.id order By animal.country.id ;
3 Answers
+ 3
insert into animals
values('Slim','Giraffe',1);
SELECT animals.name,animals.type, countries.country
FROM animals INNER JOIN countries
ON animals.country_id=countries.id order By country ;
+ 2
Simba thank you bro
0
Hi Ramesh. Were u able to submit the zoo questions with this simba's code because I have used it and several others means it keeps giving me no input it has refused to congratulate me that am done with the problem for days now. Is there anything wrong with the SQL?