I think I see what the problem is now. My first attempt was with Reservation and Paid Guest tables only and combine the queries to check all bookings. But, I was trying to use LEFT JOIN for the view. The inheritance example shows using UNION for a similar problem, which I think will take away my headaches.