Re: [Emerald] project for the day

Dale E. Reed Jr. ( (no email) )
Mon, 07 Feb 2000 12:18:02 -0800

Kenneth Gustav Eitenmiller Jr wrote:
> Now i am getting this...

Ok. Let me actually look at this. :( I'm a little under the
weather today...

> Select ii.TaxID, beforetax=sum(ii.amount*ii.quantity), taxes=sum(,
> total=sum(ii.amount*ii.quantity)+sum(
> From Invoices i, InvoiveItems ii
> Where i.InvoiceID = ii.InvoiceID
> and i.Type <> "VOID"
> and i.Date between @begindate and @enddate
> Group By ii.TaxID
> Order By ii.TaxID


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list (including removal) go to: