select t1.id,
       max(case 
             when t2.type_id =  1 
               then t2.value
             else ''
           end) val_type_1,
       max(case 
             when t2.type_id =  2 
               then t2.value
             else ''
           end) val_type_2,
       max(case 
             when t2.type_id =  3 
               then t2.value
             else ''
           end) val_type_3,
       max(case 
             when t2.type_id =  4 
               then t2.value
             else ''
           end) val_type_4
  from table1 t1
  left outer join 
       table2 t2
    on t1.id = t2.record_id 
 group by 
       t1.id

Query finished, retrieving results...

ID   VAL_TYPE_1   VAL_TYPE_2   VAL_TYPE_3   VAL_TYPE_4
--   ----------   ----------   ----------   ----------
  1    B            A                         C
  2 
  3    A

 3  row(s) retrieved