create cursor tt (f1 c( 1 ),f2 c( 1 ),f3 c( 1 ))
insert into tt values ("а","к","у") 
insert into tt values ("п","к","в")

create cursor tt2 (f1 c( 1 ),f2 c( 1 ))
insert into tt2 values ("а","е") 

#if .f.
 1 | 2 | 3 | 4  
а|к|у|е 
п|к|в|- 
#endif 

select  t1.f1 ;
       ,t1.f2 ;
       ,t1.f3 ;
       ,Nvl(t2.f2,"-") ;
	from tt t1 ;
		left join tt2 t2 on t1.f1=t2.f1

create cursor t1 (id i,value c( 10 ))
insert into t1 values( 1 ,'1')
insert into t1 values( 2 ,'2')
insert into t1 values( 3 ,'3')

create cursor t2 (id i,value c( 10 ))
insert into t2 values( 2 ,'2')

* вариант  1 
insert into t2 (id, value) ;
	select id, value ;
		from t1 ;
		where t1.id not in (select id ;
								from t2)
								
* вариант  2 
insert into t2 (id, value) ;
	select id, value ;
		from t1 ;
		where not exists (select * ;
								from t2 ;
								where t2.id=t1.id)
								
select * ;
	from t2