nicht angemeldet
Hi,
Aliasnamen aus der Select-Klausel stehen in der WHERE-Klausel nicht zur Verfügung. Du musst da schon den Ausdruck nochmal angeben.
...bzw. nachdem das ja genau ein Produkt der GROUP-BY-Anweisung ist einfach das zugehörige HAVING verwenden.
MfG
Rouven
--
-------------------
He is entertaining both out of the car and in the car because if you tell him that a corner is almost flat then he is the guy who is going to try to take it flat even if it means shunting it the other side of it, he will come with the data and say 'hey, I may have crashed and destroyed the car, but I was flat-out'. That is an interesting quality that he has! -- Team Member on Jacques Villeneuve
-------------------
He is entertaining both out of the car and in the car because if you tell him that a corner is almost flat then he is the guy who is going to try to take it flat even if it means shunting it the other side of it, he will come with the data and say 'hey, I may have crashed and destroyed the car, but I was flat-out'. That is an interesting quality that he has! -- Team Member on Jacques Villeneuve