Hi
I cant get this example to work either.
I used ORDER BY instead of GROUP BY.
Tom
----- Original Message -----
From: Leon Atkinson <[EMAIL PROTECTED]>
To: FreeTrade <[EMAIL PROTECTED]>
Sent: Wednesday, July 12, 2000 6:24 PM
Subject: RE: [FreeTrade] Listing orders with status
> > Does anybody know if this is legitimate SQL to use the
> > same table twice or have I just made use of a quirk
> > that happens to work?
>
> It is legitimate to have the same table appear more than once
> in a query.
>
> >
> > I liked the other example which was something like:
> >
> > SELECT Invoice
> > FROM invoice_status
> > WHERE Status=1 AND Created=MAX(Created)
> > GROUP BY Invoice
> >
> > But couldn't get it to work. "Invalid use of group function"
>
> You need ORDER BY, not GROUP BY.
>
> Leon
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Site: http://www.working-dogs.com/freetrade/
> Problems?: [EMAIL PROTECTED]
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
