sql question

Hi,
How can this be rewritten as a single SQL script?

declare
sumtot number;
sum1 number;
sum2 number;
begin
select sum(column) into sum1 from table where condition1; select sum(column) into sum2 from table where condition2; sumtot:=sum1-sum2;
end;

Thank you in advance Received on Sun Sep 19 2004 - 03:59:19 CDT