0
May someone tell me what is wrong with this code
INSERT INTO Animals VALUES ('Slim','Giraff',1); SELECT Animals.Name,Animals.Type,Countries.country FROM Animals INNER JOIN Countries ON Animals.country_id = Countries.ID ORDER BY Countries DESC;
2 RĂ©ponses
+ 3
Giraff(e) đŠ
+ 1
Shamson Yacoub
See here my code
You will got your mistake:
/* name - "Slim", type - "Giraffe", country_id - 1 */
INSERT INTO Animals(name, type,country_id)
VALUES('Slim','Giraffe',1);
SELECT Animals.name, Animals.type, Countries.country
FROM Animals
INNER JOIN Countries
ON Animals.country_id = Countries.id
ORDER BY Countries.country;