Thank you. That did answer the question that I had posted.

--Sample Data

CREATE TABLE Child(

App_ID char(10),

Major char(6)

);

INSERT INTO Child VALUES

( '004540036', 'GEBOX'),

( '004540036', 'GEBOX'),

( '004540036', 'GEBOX'),

( '004540036', 'GEBOX'),

( '124544037', 'JKIUTY'),

(...

Thank you for your reply. I already know that the Health table will not have as many records as the Child table. The rev_id can be assigned to more than...

Thank you for the information. I edited my post to reflect more information.