Ayuda consulta sql

[gnzsoloyo]

Pruébalo así y veamos:

Código MySQL:

SELECT tp.id_parc 
FROM TParcela tp 
WHERE NOT EXISTS
    (SELECT *
    FROM TReserva tr 
    WHERE 
        TP.id_parc = tr.id_parcela  AND
        (tr.dia_reserva BETWEEN '2010-04-15' AND '2010-04-19')
        AND 
        (tr.dia_salida BETWEEN '2010-04-15' AND '2010-04-19'));