Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: newbee question

Re: newbee question

From: André Hartmann <andrehartmann_at_hotmail.com>
Date: Fri, 23 Jul 2004 18:06:08 +0200
Message-ID: <41013770$1@olaf.komtel.net>


> What I want is for every invoice the list of item and the list of
> account and since I do sum of amount, every time that some are repeted
> the sum is not correct

Well, then I suggest you have one select statement that fetches all items and another select statement that fetches all accounts. do not mix both into one statement. in that, accounts wont get in the way of items... Received on Fri Jul 23 2004 - 11:06:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US