Create Cursor t1 ( Region_name v( 10 ), Street_type v( 10 ), Street_name v( 10 ), Street_id i)
Insert into t1 values( "Мск обл", "Ул", "Ленина",  1 )

Create Cursor t2 ( Region_name v( 10 ), Street_type v( 10 ), Street_name v( 10 ), Street_id i)
Insert into t2 values( "Мск обл", "Ул", "Виноградная",  1 )
Insert into t2 values( "ЦЦЦ обл", "Ул", "Абрикосовая",  2 )
Insert into t2 values( "Мск обл", "Ул", "Ленина",  3 )


Update t2 set Street_id=t1.Street_id ;
	from t1,t2 ;
	where   t1.Region_name=t2.Region_name ;
	    and t1.Street_type=t2.Street_type ;
	    and t1.Street_name=t2.Street_name 
	    
Select * from t2