dideldu: MAX MIN Selektion

Beitrag lesen

...
AND (SELECT (e.[Quantity] - f.[Quantity] ) As 'Diff'
      FROM e, f
      WHERE e.[Version No_] IN (SELECT MAX(d.[Version No_])
                                FROM d
                                WHERE ...)
        AND f.[Version No_] IN (SELECT MIN(d.[Version No_])
         FROM [KARSTADT_Warenhaus_GmbH$Sales Line Archive] d
         WHERE ...)
      ) > 0

die Abfrage läuft immer - :))

andere Idee