Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: newbee question
> 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
![]() |
![]() |