create table tmp
(
id integer,
global_name varchar( 50 ),
address_name varchar( 50 ),
DIST_NAME varchar( 50 ),
MOBILE_NAME varchar( 50 )
)

insert into tmp 
Select gl.[id] as id,  
       gl.[NAME] as global_name,       
       ad.[NAME] as address_name,       
       ds.[name] as DIST_NAME,       
       mb.[name] as MOBILE_NAME
FROM   global gl,
       adress ad,     
       dist ds,     
       mobile mb,
       region reg     
where gl.[id] = ad.[global_id]
and   gl.[id] = mb.[global_id]
and   ad.[id] = reg.[adress_id]
and   ds.[id] =  reg.[dist_id]