From: Martijn Tonies
Date: June 16 2004 7:06am
Subject: Re: Error 1250 Table from one of the SELECT's cannot be used in global ORDER clause
List-Archive: http://lists.mysql.com/mysql/167345
Message-Id: <00f401c45370$685b1a20$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi Dave,

> Unfortunately species_id is a column I am using for joining so I need the
> fully qualified name both in the SELECT and the ORDER BY.

What does the join have to do with the ORDER BY?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com