I have a problem that I am not able to solve yet:
Number (One to many) Number
DateTime in DateTime in
DateTime out DateTime out
How can I get the numbers from table1 where the table1 “DateTime in” to “DateTime out” is not in Table2 “DateTime in” to “DateTime out” Table2?
(Table1 is a record of a rentcar.
Table2 are records of planned car-rentals.
I have to look of a car is free between a certain period.)
In other words: I have to look if a car can be planned to be rented and therefore I have to look in the table2 where are the records of the planned rentals.
The period between the dates of table1 must not be in table2.
Can you please help me?
Thanks in advance,
Henk van den Boogaard