check this out,
Declare @ID int;
insert into Table1(Name, Age)
values (Name,Age)
set @ID = Select Max(ID) from Table 1
select * from Table2 where ID = @ID
hope it helps,
just ask me if you have a question..
don't forget to mark this as answer if it helps you,
thanks