Index: views_query.inc
===================================================================
RCS file: /cvs/drupal-contrib/contributions/modules/views/views_query.inc,v
retrieving revision 1.48.2.10
diff -u -r1.48.2.10 views_query.inc
--- views_query.inc	3 Dec 2006 17:26:21 -0000	1.48.2.10
+++ views_query.inc	3 Dec 2006 20:14:06 -0000
@@ -392,11 +392,11 @@
       // otherwise we assume it is a formula.
       if ($table) {
         $as = $alias . '_' . $f;
+        $this->add_field($f, $table, $as);
       }
       else {
-        $as = $alias;
+        $as = $alias ? $alias : $f;
       }
-      $this->add_field($f, $table, $as);
       $this->orderby[] = "$as $order";
     }
   }