Join innerhalb einer Tabelle

[DeddyH]

Ich weiß nicht, ob ich Dich richtig verstanden habe, aber vielleicht so?

SQL-Code:

SELECT dbo.V_JUMO_MEASURE.PRUEFID, AVG(dbo.V_JUMO_MEASURE.IST_WERT) FROM dbo.V_JUMO_MEASURE
where dbo.V_JUMO_MEASURE.AUFTRAG = '1323259-01' AND
      dbo.V_JUMO_MEASURE.MW_NAME = 'Widerstand T1 korrigiert' AND dbo.V_JUMO_MEASURE.PRUEFID IN
      (SELECT dbo.V_JUMO_MEASURE.PRUEFID FROM dbo.V_JUMO_MEASURE
       where dbo.V_JUMO_MEASURE.AUFTRAG = '1323259-01' AND
             dbo.V_JUMO_MEASURE.MW_NAME = 'Temperatur T1 korrigiert' AND
             dbo.V_JUMO_MEASURE.IST_WERT BETWEEN (dbo.V_JUMO_MEASURE.SOLL_WERT - 0.033) AND
             (dbo.V_JUMO_MEASURE.SOLL_WERT + 0.033))
GROUP BY dbo.V_JUMO_MEASURE.PRUEFID