I am getting Engineerid properly but EngineerName is NULL

No it is not bringing null.

Will it retrieve engineername or not?

This is from Table1.

I have just given some sample values, Duplications are allowed in this table. Because one engineer can raise any no. of bugs. only thing is bug id...

BugId EngineerId EngineerName State

10233 64867 ...

Insert into Table2(EngineerId,EngineerName)

select Distinct(EngineerId),EngineerName from Table1

where EngineerId not in (select (EngineerId) from Table2)

Why it is not retrieving EngineerName?

Cool it is working... Thanks for the gr8 help.

This is ok if the table1 does not have the repetition of EngineerId. But Table1 has the repetition of EngineerId. I've tried your code. It says Primary Key violation.

Can...