| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Having trouble with a query
>Lname Fname SSN Adult_SSN Balance_due
>-------- -------- ----------- ----------- ------------
>Cass Gary 222-33-4444 4
>Cass Donald 333-44-5555 222-33-4444 0
How about this:
SELECT parent.lname, parent.fname,
sum(payment.balance_due)
FROM table parent, table payment
WHERE nvl(payment.adult_ssn,ssn)=parent.ssn
group by parent.lname, parent.fname;
Received on Mon Dec 07 1998 - 10:58:18 CST
 |
 |