数据库问题，请各位高手解答！急！！！

[yang_lawrence]

数据库中有两个表，一个是resource,另一个是resinterview，他们都有字段email，我想将email相同的resinterview中的resinterviewId导入到resource表中的InterviewId字段中。注意，email有相同的也有不同的，需要将email相同的数据查出来。请问各位高手怎么写sql语句？

[问苍天人生几何]

--resource表
select t.[email] from
(
select [email],count(*) cnt from [resource]
group by [email]
) t
where t.[cnt]>1
----------------------
--resinterview表
select t.[email] from
(
select [email],count(*) cnt from [resinterview]
group by [email]
) t
where t.[cnt]>1

[Felixzhaowenzhong]

INSERT INTO resource
            (interviewId)
VALUES      (SELECT resinterviewId
             FROM   resinterview
             WHERE  email IN (SELECT email
                              FROM   resinterview
                              GROUP  BY email
                              HAVING Count(email) >= 2)) 

[问苍天人生几何]

--两个表之间相同email
select a.[email] from [resource] a
inner join [resinterview] b
on a.[email]=b.[email]

[yang_lawrence]

二楼的不对，insert into 是直接给resource表新增了数据，我需要的将email相同的resinterview表中的resinterviewId赋给resource中的InterviewId。