Update rows cell from another table by matching IDs [duplicate]

Question

Hi i have two tables ...

Acctive table:

SELECT * FROM 36496839_radioamater.skladovekarty00006;

CISLO NAME 1 NULL 2 NULL 3 NULL (other cells) 4 NULL 5 NULL

Helpfull table

SELECT * FROM 36496839_radioamater.skladovekarty00008;

CISLO NAME 1 one 4 four 3 tree (other cells)

And i need create a SQL code which find first row from table00008 in table00006 and copy value in NAME by matching CISLO

result:

CISLO NAME 1 one 2 NULL 3 tree (other cells) 4 four 5 NULL

and thus need to remodel an additional 12 000 rows

Can anyone help me I have desperately Thx, Martin

There is no such thing as a "first row" in a table (tables represent sets which are inherently unordered). Can you guarantee that there is only one matching row? — Gordon Linoff
– Gordon Linoff, Commented May 16, 2014 at 20:31

juergen d · Accepted Answer · 2014-05-16 20:33:30Z

4

update 36496839_radioamater.skladovekarty00006 d join 36496839_radioamater.skladovekarty00008 s on s.CISLO = d.CISLO set d.NAME = s.NAME

answered May 16, 2014 at 20:33

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

thx ... all works ... i love you :)