Inserting multiple records from one table to another table

Question

Iam inserting multiple records from one table to another table like

INSERT INTO table3 ( iSysRecDeleted, iUserId ) SELECT table2.iDeleteId, (SELECT iUserIdOld FROM table1 WHERE table1.col1=table2.col2) FROM table2

But it is giving me "Sub query returns more than 1 row".iUserIdOld had multiple entries with repetive in table1.Also I have to insert column3 from another table which will be not relevant to table1 and table2 so I don't have to use Join.Could anyone please tell me to do it in a right way. Thanks in advance.

Jens · Accepted Answer · 2014-09-24 05:40:42Z

1

Try this:

INSERT INTO table3 ( iSysRecDeleted, iUserId ) SELECT table2.iDeleteId, table1.iUserIdOld from table2 join table1 on table1.col1=table2.col2

answered Sep 24, 2014 at 5:40

Jens

69.6k15 gold badges107 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jens Over a year ago

@Gautam3164 That means? There is nothing in your question, that shows your new problem.

GautamD31 Over a year ago

@Jens please see the edited question..Till I dont want to insert 3rd column from another table your query is working fine

Jens Over a year ago

@Gautam3164 Can you show some more deatils so that I can understand the problem? Where the third column comes from and how can you get a single reord from this.

Collectives™ on Stack Overflow

Inserting multiple records from one table to another table

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related