newbie needs help: can I "order by" before "grouping"?

2003-08-07 Thread Michael Winston
I'm having trouble ordering my results before grouping them. I don't want to go into too much detail, so my simplified query without any grouping or ordering results in: ++---++ | jobnum | milestone | shipdate | ++---++ | 96-655 |

RE: newbie needs help: can I "order by" before "grouping"?

2003-08-06 Thread Kevin Fries
ou're seeing the shipdate from, for example, the minimum milestone for the job, then the query will be more complicated. Kevin > -Original Message- > From: Michael Winston [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 06, 2003 11:51 AM > To: [EMAIL PROTECTED] > S