Salida de personas de rayen

dump_rayen.sql

SELECT
	(char(34)+u.RUT+char(34)) AS RUT, 
	(char(34)+u.NOMBRES+char(34)) AS NOMBRES, 
	(char(34)+u.APELLIDO_PATERNO+char(34)) AS APELLIDO_PATERNO, 
	(char(34)+u.APELLIDO_MATERNO+char(34)) AS APELLIDO_MATERNO, 
	char(34)+CONVERT(VARCHAR(10),u.FECHA_DE_NACIMIENTO,20)+char(34) AS FECHA_NACIMIENTO,
	SEXO = CASE u.HL7_0001_U_ID
         WHEN 3 THEN 1
         WHEN 2 THEN 2
         ELSE 1
      END,
	char(34)+CONVERT(VARCHAR(10),u.FECHA_INSCRIPCION,20)+char(34) AS FECHA_INSCRIPCION,
	char(34)+c.NOMBRE+char(34) AS PREVISION,
	char(34)+n.RAZON_SOCIAL+char(34) AS NODO,
	char(34)+s.NOMBRE+char(34) AS SECTOR,
	char(34)+CONCAT(f.CALLE, ' ', f.CASA, ' ', f.BLOCK, ' ', f.DEPTO)+char(34) AS DIRECCION1,
	char(34)+f.TELEFONO1+char(34) AS TELEFONO1,
	char(34)+f.TELEFONO2+char(34) AS TELEFONO2
FROM USP_USUARIO_APS AS u
INNER JOIN CNP_CONVENIO_PREVISIONAL AS c ON c.id = u.CNP_ID
INNER JOIN NOD_NODO AS n ON n.id = u.NOD_ID
LEFT JOIN FAM_FAMILIA AS f ON f.id = u.FAM_ID
LEFT JOIN SEC_SECTOR AS s ON s.id = f.SEC_ID