select 
id as Ид, 
"NUMBER" as "Номер телефона",
client_name_short as "ФИО клиента", 
division_name as "Подразделение",  
abonent_name as "Абонент",
number_alias as "Дополнительный номер" 
from line_list@phones
LEFT OUTER JOIN CLIENTS ON (LINE_LIST.ID_CLIENT = CLIENTS_ID and line_list.date_remove is null)
where client_id_categ in (1,2)  and
         clients.archiv = 0
order by client_name_short, division_name