Index: views_query.inc =================================================================== RCS file: /cvs/drupal-contrib/contributions/modules/views/views_query.inc,v retrieving revision 1.48.2.7 diff -u -r1.48.2.7 views_query.inc --- views_query.inc 30 Nov 2006 18:45:03 -0000 1.48.2.7 +++ views_query.inc 1 Dec 2006 20:00:48 -0000 @@ -387,7 +387,7 @@ foreach($field as $f) { // $as = $alias . '_' . $f; // $this->add_field($f, $table, $as); - $this->orderby[] = "$alias.$f $order"; + $this->orderby[] = $alias ? "$alias.$f $order" : "$f $order"; } }