Re: Sorting and Ordering

2001-03-31 Thread Benjamin Pflugmann
Hi. Note, that when you do a GROUP BY, according to ANSI SQL you may SELECT only the columns grouped by and any grouping functions (like SUM), i.e. selecting PACK_INC would result in an error. MySQL extends ANSI SQL in that it allows to select abitrary columns, but chooses a random value from th

Sorting and Ordering

2001-03-31 Thread Scott Bowling
Hello all, I'm stumped with the following issue and I don't know how to resolve it (I think that sentence is just rhetoric) I have the following SQL Statement and results: mysql> SELECT MAST.CODE -> ,MAST.ADVRT_NBR ->