Pergunta de entrevista da empresa LexisNexis Legal & Professional

a basic SQL query scenario based . there are three tables related to each other with a anID they are loaded into target system . the future system auto-generates the id column . how will bring old value. in return I asked if I can used a custom field to being over old column interviewer said 'yes ' and interrupted me mid way saying oh ok you are almost there