UPDATE records with already data exists

[sal21]

have table1,
F1 F2 F3
1A 2 3
1A
1A

1A is a indexed filed

now possible to update the F2 and F3, based F1=1A and F2 and F3 is just filled, and F2 is null?

i need:
F1 F2 F3
1A 2 3
1A 2 3
1A 2 3


peraphs i just post and remember only to macke a new virtula table1_1 and join the F1 fields....

[HansV]

What if there are records like this?

S1824.png

Or is that impossible?

[sal21]

What if there are records like this?

S1824.png

Or is that impossible?

no possible, the combination is always:

1A 2 3

in effect 1A is a silmilar ZIP code, 2 the way, 3 the city name

not possible to have zip code with different indication.

[HansV]

You can use the following SQL:

UPDATE Table1 AS A INNER JOIN Table1 AS B ON A.F1 = B.F1 SET A.F2 = B.F2, A.F3 = B.F3 WHERE A.F2 Is Null AND B.F2 Is Not Null

[sal21]

You can use the following SQL:

UPDATE Table1 AS A INNER JOIN Table1 AS B ON A.F1 = B.F1 SET A.F2 = B.F2, A.F3 = B.F3 WHERE A.F2 Is Null AND B.F2 Is Not Null

tested and WORK!
TKS.