select * from tbl_PRJ_ProjectUpdates pu inner join tbl_PRJ_Samples s on pu.updateid = s.updateID insert into tbl_RD_Samples ( sampleId, projectId, submittedId, submittedDate, comment, shippingTracking, feedback, feedbackDate, dateShipped ) values ( , , , , , , , , )