Выбор всех абонентов подключенных сегодня к услугам передачи данных
select distinct
l.Customer_Id, l.Ip, l.Mac, e.Ip sw_ip, l.Port sw_port, sh.Serv_Id, c.Debt_Sum
from Subscr_Hist sh
inner join tv_lan l on (sh.Customer_Id = l.Customer_Id)
inner join customer c on (sh.Customer_Id = c.Customer_Id)
left outer join Equipment e on (e.Eid = l.Eq_Id)
where sh.Serv_Id in (select
s.Service_Id
from services s
where s.Business_Type = 1)
and current_date between sh.Date_From and sh.Date_To