bessere SQL Abfrage

[DeddyH]

Klappt das hier?

SQL-Code:

SELECT
  T1.Objekt AS Objekt,
  T2.Value AS Street,
  T3.Value AS City,
  T4.Value AS Number
FROM
  Table_1_Test T1
  LEFT JOIN Table_1_Test T2 ON T2.Objekt = T1.Objekt AND T2.Attribut = 'Street'
  LEFT JOIN Table_1_Test T3 ON T3.Objekt = T1.Objekt AND T3.Attribut = 'City'
  LEFT JOIN Table_1_Test T4 ON T4.Objekt = T1.Objekt AND T4.Attribut = 'Num'
GROUP BY
  T1.Objekt, T2.Value, T3.Value, T4.Value