SQL query to execute insert statement from the result of another sql query

Question

Guys i have to do a insert in to a table when there is no record found. is it possible to do it with only sql query. i tried with case and if .

Yup, I can confirm, it is possible and easy. Show us the source of what you have tried so far? — smirkingman
– smirkingman, Commented Nov 29, 2010 at 13:12

Joel Mansford · Accepted Answer · 2010-11-29 11:22:49Z

3

Just add the condition of your 'IF' to the WHERE of the INSERT for example

INSERT INTO People
(FirstName,LastName,Email)
SELECT @FirstName,@LastName,@Email WHERE @Email NOT IN (SELECT Email FROM People)

If the email address already exists in the table then the SELECT will return no rows and hence no insert will take place

answered Nov 29, 2010 at 11:22

Joel Mansford

1,3167 silver badges13 bronze badges

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

Comments

ceth · Accepted Answer · 2010-11-29 11:21:18Z

1

How about:

insert into table1 
   (select * from table2 where id not in
      (select id from table1))

answered Nov 29, 2010 at 11:21

ceth

45.5k63 gold badges191 silver badges300 bronze badges