SQL Insert Into Select Statement With 2 Criteria

Question

I have tableA, tableB and tableC like the image. TableC assumption is empty. How to insert data into tableC with Insert Into Select statement ?

Data tableC from tableB with contition from tableA.

I can do it with cursor.

can u post tables instead of images..

Chanukya
– Chanukya

2017-02-10 04:36:26 +00:00
Commented Feb 10, 2017 at 4:36 — Chanukya
– Chanukya, Commented Feb 10, 2017 at 4:36
Try this stackoverflow.com/a/25971/7036750

Prasanna Kumar J
– Prasanna Kumar J

2017-02-10 04:37:32 +00:00
Commented Feb 10, 2017 at 4:37 — Prasanna Kumar J
– Prasanna Kumar J, Commented Feb 10, 2017 at 4:37

dana · Accepted Answer · 2017-02-10 04:46:59Z

1

When possible, you should try to avoid using cursors for these types of inserts :) (think in sets)

Here is 1 way how to do it:

insert
into TableC(ColA, ColB, ColC)
select a.ColA, a.ColB, a.ColC
from TableA a
join TableB b on b.ColA = a.ColA and b.ColB = a.ColB

edited Feb 10, 2017 at 4:46

answered Feb 10, 2017 at 4:38

dana

18.3k7 gold badges71 silver badges91 bronze badges

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

Comments

Mahesh.K · Accepted Answer · 2017-02-10 05:03:31Z

0

Please try below query.

    insert into tablec(cola , colb , colc ) 
    select b.cola, b.colb, a.colc from tableb b, tablea a 
    where a.cola = b.cola and a.colb = b.colb;

edited Feb 10, 2017 at 5:03

Mahesh.K

9016 silver badges16 bronze badges

answered Feb 10, 2017 at 4:58

Akshay

112 bronze badges

Collectives™ on Stack Overflow

SQL Insert Into Select Statement With 2 Criteria

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related