I need to do a insert in a specific row after a select with inner join to know which row

Question

I did

SELECT F.id
FROM ftable F 
  INNER JOIN dtable D ON (F.id= D.id) 
WHERE D.email = 'abc@abc.com';

now I need to do a insert in a ftable column using the select result as the where indicator.

Possible duplicate of [INSERT with SELECT](http://stackoverflow.com/questions/5391344/insert-with-select) — Sunny Patel, Apr 11 '17 at 17:51
`INSERT INTO f VALUES(x,y,z) WHERE f.id IN ();` should do the trick. — JNevill, Apr 11 '17 at 17:51
@Rams I need to do a insert in a specific ftable row. To know that row, I did a select (query above), but I don't know how to do the select and the insert in the same query — lufizi, Apr 11 '17 at 17:58

score 0 · Answer 1 · answered Apr 11 '17 at 18:08

0

You can simply insert those selected values by putting insert into before ur select.

Insert into ftable
    SELECT F.* FROM ftable F 
                INNER JOIN dtable D ON (F.id= D.id) 
                WHERE D.email = 'abc@abc.com';

answered Apr 11 '17 at 18:08

Rams

1 Answers1