> Don't follow your question - you suggested I use the column name (with no
> table name) as the ORDER BY. I said I can;t do this because I join on that
> column name - this means any references to it MUST be qualified with a
Actually, I suggested to use "ORDER BY 1 ASC"
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
> Anyway - reported this as a 4.1.2 bug (on the grounds that it used to work
> in 4.0.17) and have just been told the bug was in 4.0.17, which should not
> have allowed this behaviour!
> >Hi Dave,
> > > Unfortunately species_id is a column I am using for joining so I need
> > > 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
> >Upscene Productions
> >MySQL General Mailing List
> >For list archives: http://lists.mysql.com/mysql
> >To unsubscribe: