Re: Programming in SQL?

I think this depends on your version of Oracle...

You could make a view of the summed table (B) and select from this to table A, or in O8 you can put the select statement for the sum as one of the table entries in the FROM clause.

You need to be careful because you can't do a correlated subquery style select in the from clause... but it can definitely be done.

hth
Randy

amerar_at_ci.chi.il.us wrote:
>
> Hello,
>
> I am trying to create a very interesting query and I'm not sure if it
> can be done.
>
> I have two tables: Table A and Table B. There is a one to many
> relationship from Table A to Table B. What I want to do, for the dollar
> amount fields, is for matching records in the tables, I want sum the
> records in Table B first, then add it to the field in Table A.
>
> So,
>
> Table A has one record with a dollar amount of $100.
> Table B has three records with dollar amounts $100, $100 and -$100.
>
> I want to sum those records in Table B BEFORE adding them to Table A.
>
> Can this be done or am I stuck writing a PL/SQL procedure?
>
> Please send a copy to my e-mail.
>
> Thanks,
>
> Arthur
> amerar_at_ci.chi.il.us
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 26 1999 - 14:02:45 CDT