How do I solve the problem in SQL server

Question

1.00/5 (1 vote)

See more:

I have two tables in that first table have 5 columns and second table have 10 columns then my question is i want to insert values into first table that is only two columns i have to insert and remaining three columns should be take from second table that first table id = second table id matchable in that first table and second table have that three columns name are same i dont know how to i solve this problem

What I have tried:

i dont know how to solve this problem

Posted 6-Jun-17 0:45am

Member 13230427

Updated 6-Jun-17 7:16am

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2017-06-06T01:11:00

First off, that's a bad idea because it means you have duplicated data - and depending on what the data is that could mean significant wasted space in your DB. If you already have a foreign key relationship between the two tables it's a lot easier (and safer, as the data can't get out of sync if it isn't duplicated) to use a JOIN when you try to retrieve the info:

SQL

SELECT a.Col1, a.Col2, b.Col1, b.Col2, b.Col3 FROM MyFirstTable a
JOIN MySecondTable b ON a.Id = b.OtherTableId

If you must do the INSERT in a dangerous and poor design manner though, you can use an SQL INSERT INTO SELECT Statement[^].

Richard MacCutchan · Answer 2 · 2017-06-06T01:13:00

Solution 2

sql join - Google Search[^]

Posted 6-Jun-17 1:13am

Richard MacCutchan

RickZeeland · Answer 3 · 2017-06-06T07:16:00

Solution 3

Maybe something like this:

SQL

INSERT INTO table1 ([ID],[Name],[Address])  
	SELECT [ID],[Name],[Address] FROM table2

Posted 6-Jun-17 7:16am

RickZeeland