update query

[ahmedbasheer]

hello
i have 2 table in data base
the first tabl1 have 3 columns ([id] as number and [first_Name] as text and [Last_Name] as text)
but the [Last_Name] column in first tabl1 is null (dont have any data)

in the second tabl2 have 2 columns ([id] as number [Last_Name] as text )

i need transfer data in columns [Last_Name] from tabl2 to [Last_Name] in tabl1 where tabl1.id =tabl2.id
using update query
i attach example



thank you for help me

[andy49]

Do you need to do this? A normal select query joins the two tables on ID would show the info you need.

[ahmedbasheer]

id	ferst_name	last_name
1	ali
2	ahmed	hasan
3	sali	kais
4	sara
5	noor	omar
6	mona	adnan

thank you for reply

no
i need use update query to transfer data in tabl2 column last_name to tabl1 in column last_name
where id column in tabl2 = column in tabl1
like this table
i need this final result in tabl1 when i started the update query
without relation ship

thanks

[June7]

UPDATE tabl1 INNER JOIN tabl2 ON tabl1.id = tabl2.id SET tabl1.last_Name = [tabl2].[last_Name];

Easily built with the Access query builder.

[ahmedbasheer]

thank you very math