| 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: Combining two SQL Statements
select
userid,
sum(usedslots) usedslots,
sum(freeslots) freeslots,
sum(usedslots + freeslots) totalslots
from
user_used_slots used,
user_free_slots free
where used.userid = free.userid
group by userid;
Wario Received on Thu Oct 07 2004 - 12:50:58 CDT
 |
 |