- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
select
PTS.*,
(select client_type_id from clients where client_id = PTS.client_id) as client_type_id,
(select name ||''|| address from ats_list
where id = PTS.ats_id) as ats_name,
(select name ||''|| ip_address from dslam_list
where id = PTS.dslam_id) as dslam_name,
(select label from point_statuses_view
where code = PTS.statuscross) as statuscross,
(select typename from asrtypes
where typename_value = '1' and typename_id = PTS.country_id) as country_name
from points as PTS
where
PTS.point_id = 118749
Комментарии (0) RSS
Добавить комментарий