select * from tbl_PRJ_ProjectUpdates pu inner join tbl_PRJ_Samples s on pu.updateid = s.updateID insert into tbl_RD_SampleDetails ( sampleId, description, pfiCode ) values ( , , )