nicht angemeldet
Hi,
die einfachste Variante wäre von Anfang an nur die Stadt-Spalte überhaupt zu selektieren, die überhaupt einen Inhalt hat. Danach kann man dann auch sicher sortieren.
Der SQL-Standard (und auch MySQL bieten hierzu den COALESCE-Operator an, der soviel heißt wie "gib mir aus deinen Argumenten den ersten NICHT-NULL-WERT sofern vorhanden".
SELECT ..., COALESCE(g.stadt, v.stadt) AS stadt
FROM ...
ORDER BY stadt
Sollte das Statement nicht funktionieren, versuch mal einen anderen Namen als stadt zu verwenden, es kann sein, dass das DBMS sich nicht ganz sicher ist welches Stadt gemeint ist.
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