Advertisement
Guest User

Untitled

a guest
Nov 20th, 2014
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. String query = "SELECT t.name FROM CarType t "
  2. + "WHERE EXISTS ( "
  3. + "SELECT car.id FROM Car car "
  4. + "WHERE car.type = t "
  5. + "AND NOT EXISTS ( SELECT r.id FROM Reservation r "
  6. + "WHERE r IN (car.reservations) "
  7. /*+ "AND ( (r.startDate > :start AND r.startDate < :end) "
  8. + "OR (r.endDate > :start AND r.endDate < :end) "
  9. + "OR (r.startDate <= :start AND r.endDate >= :end) "
  10. + ") "*/
  11. + ") "
  12. + ") "
  13. + "ORDER BY t.rentalPricePerDay ASC";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement