Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.03 » View Incident Report |
Serious |
Reported By: Tiago Ameller Reported On: 3/17/2010 For: Version 2.03 Build 9 |
SELECT Matricula, M.Nombre AS Nombre_Marca, Modelo, SUBSTRING(T.Nombre,1,15) AS Nombre_Tipo, NumTarjeta, Clase, CaducidadTarjeta, NOMBRECOMPLETO(C.RAZONSOCIAL,C.APELLIDO2,C.NOMBRE) AS Nombre_Completo, DOMICILIOCOMPLETO(SV.Sigla,C.ViaPublica2,C.NumeroVia2, C.Escalera2,C.Piso2,C.Puerta2) AS Domicilio_Completo, MUNICIPIOCOMPLETO(C.CPostal2,C.Municipio2,PR.Nombre) AS Municipio_Completo, ExpedicionTarjeta, Ambito, C.NIF FROM MAVEHICU INNER JOIN MAMARVEH M ON (M.CODIGO = MARCA) INNER JOIN MATIPVEH T ON (T.CODIGO = TIPOVEHICULO) INNER JOIN MACLIENT C ON (C.NIF = PROPIETARIO) INNER JOIN MASIGLAV SV ON (C.SiglaViaCod2 = SV.Codigo) INNER JOIN MAPROVIN PR ON (C.Provincia2 = PR.Sigla) WHERE CADUCIDADTARJETA BETWEEN :DFecha AND :HFecha AND BLOQUEADO = FALSE AND HISTORICO = FALSE AND C.NOQUIEREAVISOS = FALSE AND C.BLOQUEADO = FALSE AND C.HISTORICO = FALSE ORDER BY C.NIF
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |