RE: [FreeTrade] Listing orders with status

[Leon Atkinson]

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