List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:August 4 1999 2:40pm
Subject:Sorting by invisible field
View as plain text  
>>>>> "Para-dox" == Para-dox  <paradox@stripped> writes:

Para-dox> I have the following query:
Para-dox> SELECT INVNUM, SUBTOTAL + ROUND(SUBTOTAL*TAXPERC) AS BAH FROM INVOICES ORDER
Para-dox> BY BAH;

Para-dox> how can I do this same this but instead of having to get the BAH column, all
Para-dox> I get is the INVNUM column?

Para-dox> (SELECT INVNUM FROM INVOICES ORDER BY SUBTOTAL+ROUND(SUBTOTAL*TAXPERC);
Para-dox> doesn't work.)

Hi!

The later query is not allowed in ANSI SQL (but MySQL 3.23.2 will
support it:)

Regards,
Monty
Thread
Sorting by invisible fieldPara-dox4 Aug
  • Sorting by invisible fieldMichael Widenius4 Aug
  • Re: Sorting by invisible fieldPara-dox4 Aug
  • Re: Sorting by invisible fieldRalph Graulich4 Aug
RE: Sorting by invisible fieldadhir5 Aug
  • RE: Sorting by invisible fieldRalph Graulich5 Aug