Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #11
- SELECT name
- FROM (
- SELECT * FROM reservation r
- JOIN entity e ON e.client_id = r.client_id
- )s
- WHERE to_date('17-04-2019', 'DD-MM-YYYY')>arrival_date AND to_date('19-04-2019', 'DD-MM-YYYY')<departure_date
- GROUP BY s.name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement