DB object question

[xinyiman]

Hello guys, someone can tell me if there are objects for which I compared with a record of a hypothetical table t_1 (IdMan, Name, City) with = 1 IdMan I go to insert into a table named hypothetical T_2 (IdMan, IdJob) the two following values
1, 1
1, 2

Where the table T_3 (IdJob, Job) is composed
1, "Student"
2, "Programmer"
3, "Professor"