+ 1

Can anyone help me adding a new entry into the table and join it another table

New entry to the table

29th Mar 2021, 4:17 PM
Sharique Abraar
Sharique Abraar - avatar
8 Antworten
+ 2
I remember someone asked about this task before. So I'd like to suggest you to try and search the forum for similar cases, just in case someone had answered it already 👍
29th Mar 2021, 4:38 PM
Ipang
+ 2
The following module covers how to insert data into a table, and how to join tables. It's the first part of "JOIN, Table operations" module, so you might want to review it. https://www.sololearn.com/learn/SQL/1865/ Please edit the thread to add SQL in the tags 👍
29th Mar 2021, 4:32 PM
Ipang
+ 2
Please verify my code below INSERT INTO Animals (name,type,country_id) values ('Slim','Giraffe',1) select Animals.name, Animals.type,Countries.country from Animals JOIN Countries ON Animals. country_id = Countries. id order by country
29th Mar 2021, 4:34 PM
Sharique Abraar
Sharique Abraar - avatar
+ 1
Please tag a relevant language, the word "table" can mean HTML or SQL table, it's contextual. P.S. It seems you had accidentally posted this twice. Kindly remove either one to help reduce duplicate questions 👍
29th Mar 2021, 4:25 PM
Ipang
+ 1
It's giving an error not sure where am I going wrong. I was taking a test in sololearn and it's my last challenge.
29th Mar 2021, 4:37 PM
Sharique Abraar
Sharique Abraar - avatar
+ 1
Got the answer I missed semi colon in the insert into statement
29th Mar 2021, 5:46 PM
Sharique Abraar
Sharique Abraar - avatar
0
It's a SQL table
29th Mar 2021, 4:28 PM
Sharique Abraar
Sharique Abraar - avatar
0
Does it work, have you tested yet? Was there an error message or is it giving you wrong output?
29th Mar 2021, 4:35 PM
Ipang