Dynamic update - add one table to another

[Anonymous]

what Dynamic table statement (yes I really need Dynamic statement - not looking for another solution)

can I use to add the content on table 2 to table 1 so table 1 will look like

Name	Score
A	1
B	2
C	3
D	4
E	10
F	20

something like : Update table1 set ...

starting point:

table1:

LOAD * INLINE [

    Name, Score

    A, 1

    B, 2

    C, 3

    D, 4

];

Qualify *;

table2:

LOAD * INLINE [

    Name, Score

    E, 10

    F, 20

];

unQualify *;

Many thanks,

Raphael

[Anonymous]

many thnaks