+ 1

INSERT INTO Animals VALUES('Slim','Giraffe',1) ; SELECT Animals.name, Animals.type, Countries.country FROM Animals INNER JOIN

Not getting result, help me out of this

27th May 2021, 11:39 AM
Harshitha
10 Antworten
+ 2
INSERT INTO Animals VALUES ('Slim','Giraffe',1); SELECT name, type, country FROM Animals, Countries WHERE country_id = id ORDER BY country;
27th May 2021, 11:44 AM
visph
visph - avatar
+ 1
Even though, its not clearing.
27th May 2021, 11:51 AM
Harshitha
+ 1
what do you mean by "its not clearing"? the provided code I've posted works fine ^^
27th May 2021, 11:52 AM
visph
visph - avatar
+ 1
😔, but it's not working for me, I checked multiple times
27th May 2021, 11:53 AM
Harshitha
+ 1
you may have not copying my code exactly ;P
27th May 2021, 11:54 AM
visph
visph - avatar
+ 1
Sorry to trouble you and thankyou, it is okay now.
27th May 2021, 11:57 AM
Harshitha
+ 1
you didn't trouble me, except by removing the "best answer" mark from my working solution ;P
27th May 2021, 12:05 PM
visph
visph - avatar
+ 1
Oh sry, I don't know that, unfortunately I didn't recognise it. I'm very new to this platform.
27th May 2021, 12:14 PM
Harshitha
+ 1
no problems... that's fine to set best answer mark, and even to remove it if you think it doesn't deserve that... however, as you was recognizing finally that I have give you the right solution, it would be unfair to not set it again ;)
27th May 2021, 12:19 PM
visph
visph - avatar
+ 1
Yeah
27th May 2021, 12:23 PM
Harshitha