SQL INSERT INTO 2 tables( table 1 ID is used in table 2)

1
votes

This is my table 1: ID column is auto incremented (identity)

ID NAME CITY AGE
1  Tom   LA   22
2  Lucy  Boston 23

This is my table 2: (ID comes from table 1)

ID NUMBER
1  555-1111
2  555-2222
2  555-22222

This is my table3: ID column is auto incremented (identity)

ID NAME CITY AGE    NUMBER
1  John   LA   25   555-3333
2  AMy  Boston 26   555-4444

I want to insert data into table 1 and table2 from table 3, finally get the results as below:

table 1:

ID NAME CITY AGE
1  Tom   LA   22
2  Lucy  Boston 23
3  John   LA   25   
4  AMy  Boston 26

table 2:

ID NUMBER
1  555-1111
2  555-2222
2  555-22222
3  555-3333
4  555-4444

How to INSERT into 2 tables from one statement? Is it possible? Please help.

sqlite