<?xml version="1.0" encoding="iso-8859-1"?>
<turisoftreportfile title="Inquilinos principales repetitivos" breakpoint="" group="">
	<parameters>
		<param name=":1" description="Desde fecha de entrada" type="DATE" order="1" show="yes" default="" />
		<param name=":2" description="Hasta fecha de entrada" type="DATE" order="2" show="yes" default="" />
	</parameters>
	<sql>SELECT 
	COUNT(*) AS reservas."Reservas",
	inqui."Nombre" AS inqui."Inquilino",
	inqui."Código" AS inqui.ID,
	inqui."NIF/Pasaporte" AS inqui."Documento",
	inqui."Móvil",
	inqui."Teléf. (I)" AS inqui."Teléfono",
	inqui."E-mail",
	inqui."País"
FROM
	inqui,
	reservas
WHERE 
	reservas.Desde &gt;= &#39;:1&#39;
	AND reservas.Desde &lt;= &#39;:2&#39;	
	AND reservas.Inquilino=inqui."Código"
	AND reservas.Agencia &gt;= -1
GROUP BY
	inqui."Nombre",
	inqui."Código",
	inqui."NIF/Pasaporte",
	inqui."Teléf. (I)",
	inqui."Móvil",
	inqui."Fax",
	inqui."E-mail",
	inqui."País"
HAVING
	COUNT(*) &gt; 1
ORDER BY
	inqui.Nombre

</sql>
	<totals>
	</totals>
	<footer></footer>
</turisoftreportfile>
