INSERT SELECT

[seppel]

hi,

a | b | c | d |
1 | 5 | 6 | 3 |
2 | 4 | 5 | 3 |
3 | 7 | 2 | 3 |
4 | 5 | 1 | 4 | <-
5 | 4 | 2 | 4 | <-
6 | 7 | 3 | 4 | <-

7 | 5 | 1 | 5 | <-
8 | 4 | 2 | 5 | <-
9 | 7 | 3 | 5 | <-

insert into Table (a,b,c,d) values(select a,b,c,5 from Table where d=4)

so in der Art?

Gruss,
Seppel