Query help

Thread view:

shaji.cc@gmail.com - 19 Jan 2006 10:02 GMT

Hi:

I need a help in aggreagete queries.

I have an order table.
(id, name, date)

I have another order-item table
(id, name, amount, orderid) orderid is foreign key.

Now I want to get a report like this
order-name, orderid, date, totalamount
--> where totalamount is the sum of corresponding
amounts from order-item.

Can anybody help me suggesting an aggregate query.

-spa.

Reply to this Message

IchBin - 19 Jan 2006 20:45 GMT

> Hi:
>
[quoted text clipped - 14 lines]
>
> -spa.

Think you want something like this..

SELECT o.NAME, o.ID, o.DATE, SUM(i.AMOUNT)
FROM orderTable o, orderItem i
WHERE o.id = i.id
GROUP BY o.NAME, o.id, o.DATE;

Signature

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA
http://weconsultants.servebeer.com/JHackerAppManager
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

Reply to this Message

IchBin - 19 Jan 2006 20:49 GMT

> Think you want something like this..

Sorry

SELECT o.NAME, o.ID, o.DATE, SUM(i.AMOUNT)
FROM orderTable o, orderItem i
WHERE o.id = i.ORDERID
GROUP BY o.NAME, o.id, o.DATE;

Signature

Reply to this Message

Query help

Free Magazines