insert into table with nest query

Readers,

table1
column1,column2
value1,value2

table2
column2,column3
value2, value3

table3
column1,column2,column3
value1,value2,value3

When value3 is first entered into table2, what are the correct
commands for value2 (in table2) and value1 (in table1) to be selected
for insertion into table 3?

INSERT INTO table3 SELECT ... WHERE value3='...';

The conceptual difficulty is how to use nested query correctly, or is
there a better method? Thank you.