Daten innerhalb einer Tabelle vervielfältigen

[mkinzler]

Ich würde es so versuchen:

SQL-Code:

update (
  select 
    t1.a, t1.b, t1.c, t1.e te, t1.f tf, t2.e, t2.f
  from
    <Tabelle> t1
      join <Tabelle> t2 on t2.a = t1. a and t2.b = t1.b and t2.c = t1.c and t2.g is not null
  where 
    t1.g is null)
set 
  e = t1, f = tf;