Ayuda consulta sql

[gnzsoloyo]

EXCEPT no existe en MySQL, lo que puedes usar es otra forma:

Código MySQL:

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