Update rows cell from another table by matching IDs

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, May 16 '14 at 20:31

score 4 · Accepted Answer · answered May 16 '14 at 20:33

4

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

answered May 16 '14 at 20:33

juergen d

1 Answers1