CODEWITHSUNDEEP
sql-servert-sqlsql-insert
Liudi Wijaya
Liudi Wijaya

Reputation: 956

SQL Insert Into Select Statement With 2 Criteria

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.

enter image description here

Upvotes: 2

Views: 317

Answers (2)

Akshay
Akshay

Reputation: 11

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;

Upvotes: 0

dana
dana

Reputation: 18105

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

Upvotes: 1

Related Questions