SQL

[donna lester <donna_lester_ny@xxxxxxxxx>]

Hello.
  My sql displays as below  
  select pval,pquant,pgross from USA/ATSFILE 
where pcnty='USA'
  
pval     pquant    pgross
  1        100       100-
  1        200       200-  
2        300       300
1        400       400-
2        100       100
  PVAL will have only values either  1 or 2. I want to calculate PQUANT,PGROSS as below
  PQUANT = (PQUANT WHEN PVAL IS 2)-(PQUANT WHEN PVAL IS 1) = 300-
PGROSS should be calculated sum of all pgross values=300-
  Can some one help  to combine these calculations in my above sql statement?


Thanks,

Donna.
       
---------------------------------
Be a better Globetrotter. Get better travel answers from someone who knows.
Yahoo! Answers - Check it out.