Hallo! So geht's:
SELECT DISTINCT A.AUREFART FROM ( (SELECT AUREFART, ID FROM adimutil WHERE (AUCODDIMUT = 'Dn') AND ((AUBORNEINF = P1) OR ((AUBORNESUP > 0) AND (P1 BETWEEN AUBORNEINF AND AUBORNESUP)))) AS A INNER JOIN (SELECT AUREFART, ID FROM adimutil WHERE (AUCODDIMUT = 'Dn') AND ((AUBORNEINF = P2) OR ((AUBORNESUP > 0) AND (P2 BETWEEN AUBORNEINF AND AUBORNESUP)))) AS B ON A.AUREFART = B.AUREFART AND A.ID <> B.ID ) INNER JOIN (SELECT AUREFART, ID FROM adimutil WHERE (AUCODDIMUT = 'Dn') AND ((AUBORNEINF = P3) OR ((AUBORNESUP > 0) AND (P3 BETWEEN AUBORNEINF AND AUBORNESUP)))) AS C ON (C.AUREFART = A.AUREFART) AND (C.ID <> B.ID) AND (C.ID <> A.ID) Freundliche Gr��e Joachim van de Bruck | [aspdedatabase] als [email protected] subscribed | http://www.aspgerman.com/archiv/aspdedatabase/ = Listenarchiv | Sie k�nnen sich unter folgender URL an- und abmelden: | http://www.aspgerman.com/aspgerman/listen/anmelden/aspdedatabase.asp
