create table price_info
         (id int not null primary key,
          name varchar( 20 ) not null
         )
go
create table good
         (id int not null primary key,
          price0 money not null,
          price1 money not null
         )
go
insert into price_info values ( 1 , 'Цена0')
insert into price_info values ( 2 , 'Цена1')
insert into good values ( 104 , 23 . 5 , 24 . 5 )
insert into good values ( 105 , 21 . 3 , 29 . 3 )

select g.id, pi.id, case pi.id 
                 when  1  then g.price0 
                 when  2  then g.price1 
                 else  0 . 0  
          end as price
from good g, price_info pi