Consulta varias tablas BD

[Libras]

Código SQL:

SELECT * FROM peliculas AS pe
WHERE pelicula.tipo = 'Adulto' AND pelicula.tipo NOT IN (SELECT * FROM reservas AS re WHERE pe.id=re.id)
 

Algo asi, saludos!