imaginary dought in sql joins

Question

Hi

 

i have small dought .if im inserting record into DB (record may have multple values) and record will be inserted into 2 tables .in first table after record insertion i need  to capture ID which is recently incremented (first table ID has Identity) .and i need to insert that value into second table in same time.is it possible without single join query .or without joins (which one is best).and i would like to done this in single code block execution.any leads

 

Thanks and Regards