INSERT INTO FirstTable (id,name,ClassType)
SELECT id,name,ClassType FROM secondTableName
Where id = values
In sql you can use top 1 for getting only one record if you would get more than one record s using the where condition,
INSERT INTO FirstTable (id,name,ClassType)
SELECT top 1 id,name,ClassType FROM secondTableName
Where id = values
Thanks
Bimal