Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String query = "SELECT t.name FROM CarType t "
- + "WHERE EXISTS ( "
- + "SELECT car.id FROM Car car "
- + "WHERE car.type = t "
- + "AND NOT EXISTS ( SELECT r.id FROM Reservation r "
- + "WHERE r IN (car.reservations) "
- /*+ "AND ( (r.startDate > :start AND r.startDate < :end) "
- + "OR (r.endDate > :start AND r.endDate < :end) "
- + "OR (r.startDate <= :start AND r.endDate >= :end) "
- + ") "*/
- + ") "
- + ") "
- + "ORDER BY t.rentalPricePerDay ASC";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement