Inhalt einer Tabelle als neue Felder

[Sir Rufo]

Ungefähr so

SQL-Code:

SELECT 
  k.Key as Pers, 
  nachn.Value as Name,
  nr.Value as Nummer,
  an.Value as Anrede,
  g.Value as Geschlecht
FROM ( select distinct Key from table1 ) k
JOIN ( select Key, Value from table1 where Attribut='P0002-NACHN' ) nachn ON nachn.Key=k.Key
JOIN ( select Key, Value from table1 where Attribut='P0002-Nr' ) nr ON nr.Key=k.Key
JOIN ( select Key, Value from table1 where Attribut='P0002-An' ) an ON an.Key=k.Key
JOIN ( select Key, Value from table1 where Attribut='P0002-G' ) g ON g.Key=k.Key