SELECT
AG1."Descripción" AS AG1."Agrupación",
R1.Vivienda,
R1.Desde AS reservas.Entrada,
R1.Hasta AS reservas.Salida,
R1.Reserva,
INQ1.Nombre AS INQ1.Inquilino,
INQ1."NIF/Pasaporte"
FROM
reservas AS R1,
inqui AS INQ1,
agrupaciones AS AG1
WHERE
R1.Hasta >= ':1'
AND R1.Hasta <= ':2'
AND AG1."Código"=R1."Agrupación"
AND INQ1."Código"=R1.Inquilino
AND R1.Inquilino NOT IN (
SELECT
Inquilino
FROM
reservas
WHERE
reservas.Desde >=':2'
)
ORDER BY
AG1."Descripción",
R1.Vivienda,
R1.Desde,
R1.Hasta