Create Cursor sprav (id i, name v( 50 ))
Insert into sprav values ( 1 , 'Audi')
Insert into sprav values ( 2 , 'BMW')
Insert into sprav values ( 3 , 'Renault')


Create Cursor tt (dat d( 8 ), id_spr i, numb i)
Insert into tt values ({^ 2010 - 01 - 01 },  1 ,  10 )
Insert into tt values ({^ 2010 - 03 - 01 },  2 ,  20 )
Insert into tt values ({^ 2010 - 06 - 01 },  3 ,  8 )
Insert into tt values ({^ 2010 - 06 - 01 },  4 ,  8 )


Select t.dat ;
     , t.id_spr ;
     , Nvl(s.name,'нема') ;
     , t.numb ;
   from tt t ;
      left join sprav s on s.id=t.id_spr