Select FA.dvc39 as CLIENTE, SAT.com_conserje as CONSERJE, SAT.com_pgaraje as GARAJE, SAT.com_alarma as ALARMA, SAT.com_cctv as CCTV, SAT.com_pciext as PCIEXTINCION, SAT.com_pcidet as PCIDETECCION, SAT.com_monoxido as MONOXIDO, SAT.com_electicidad as ELECTRICIDAD, SAT.com_antena as ANTENA, SAT.com_portero as PORTERO, SAT.com_videoportero as VIDEOPORTERO, SAT.com_aire_acondicionado as AIREACONDICIONADO, SAT.cctv_dvr as CCTVDVR, SAT.cctv_capacidad as CCTVDVRCAPACIDAD, SAT.cctv_interiores as CCTVNCAMARASINTERIORES, SAT.cctv_exteriores as CCTVNCAMARASEXTERIORES, SAT.ala_ncentral as ALARMANCENTRAL, SAT.ala_modelo as ALARMANMODELO, SAT.ala_ndetectores as ALARMANDETECCTORES, SAT.ala_interiores as ALARMANDETECTINT, SAT.ala_exteriores as ALARMANDETECTEXT, SAT.ext_nbies as PCIEXTINCNBIES, SAT.ext_grupo_presion as PCIEXTINCGRUPOPRESION, SAT.ext_columna_seca as PCIEXTINCCOLUMNASECA, SAT.det_ncentrales as PCIDETECNCENTRALES, SAT.det_ndetectores as PCIDETECNDETECTORES, SAT.det_npulsadores as PCIDETECNPULSADORES, SAT.det_nsirenas as PCIDETECNSIRENAS, SAT.det_nemergencias as PCIDETECNEMERGENCIAS, SAT.mon_ncentrales as MONOXIDONCENTRALES, SAT.mon_ndetectores as MONOXIDONDETECTORES, SAT.mon_ncuadros as MONOXIDONCUADROS, SAT.mon_nmotores as MONOXIDONMOTORES, SAT.pue_npuertas as PUERTASN, SAT.pue_tipo1 as PUERTASTIPO1, SAT.pue_tipo2 as PUERTASTIPO2, SAT.com_nviviendas as NVIVIENDAS, SAT.ant_nantenas as NANTENAS, SAT.ext_nextintores as NEXITINTORES, SAT.ant_tipo_cabecera as TIPOCABECERA, SAT.ant_marca as MARCA, SAT.ant_nequipos_secu as NEQUIPOSSECUNDARIOS, SAT.ant_fi as FI, SAT.ant_tipo_fi as TIPOFI, SAT.ant_satelite as SATELITE, SAT.ant_marca_cabecera_sat as MARCACABECERASATELITE, SAT.ant_digital_comunitario as DIGITALCOMUNITARIO, SAT.ant_tcableado as TIPOCABLEADO, SAT.ant_distribucion as DISTRIBUCION, SAT.vp_tipo as TIPO, SAT.vp_tecnologia as TECNOLOGIA, SAT.vp_naccegenerales as NACCESOSGENERALES, SAT.vp_nplacas_secu as NPLACASSECUNDARIAS, SAT.vp_conserjeria as CONSERJERIA, SAT.vp_lector_proxi as LECTORPROXIMIDAD, SAT.com_mes_venci as MESVENCIMIENTOPCI, SAT.ant_ncabeceras as NCABECERAS, SAT.ant_ncabeceras_sat as NCABECERASSATELITE, SAT.vp_mportero as MARCAPORTERO, SAT.det_tipo as PCIDETECTIPO, SAT.com_puertas as PUERTAS From RPS.dbo.extra_sat SAT, RPS.dbo.faclidv FA
Where SAT.codemp = FA.codemp
AND SAT.codcli = FA.codcli

Univers0