INSERT in 2 tables

[castali]

is it possibles to insert in 2 tables ?

thank you

[ryand09]

Use 2 Append queries

[castali]

then it's impossible to do >>> insert into table1,table2 ......

update is possible ....strange that it is not for insert

thank you

[skhanal]

How do you update two tables using one UPDATE statement?.

You can join two or more tables in a UPDATE statment but SET statment can only contain columns from one table.

[castali]

UPDATE Table1, Table2 SET Table1.Name = "Pierre", Table2.Age = 21
WHERE (((Table1.Name)="Paul") AND ((Table2.Age)=20));