Field has two values- want to display both in SQL

My SQL is:

select s.stylecode "Style", s.styleidx, p2.price "Price RRP", p2.spidx from sprice_style p1, sprice_clrsku p2, style s, refcode divn where p1.styleidx=s.styleidx
and (p2.spidx = 70 or p2.spidx=2588)
and divn.name='Ck Underwear';

P2.SpIdx can be both of two values. I want to change the SQL above so that it shows something like:

select s.stylecode "Style", s.styleidx, p2.price_if_=70 "Price RRP", p2.price_if_=2588 "Price WHL", p2.spidx
from sprice_style p1, sprice_clrsku p2, style s, refcode divn where p1.styleidx=s.styleidx
and (p2.spidx = 70 or p2.spidx=2588)
and divn.name='Ck Underwear';

Is this possible?

--

Julian Milano