>>>>> "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
