Dear All..
I Have a table Employee
Employee Name Start Date End Date Smith 12/01/2017 12/03/2017 Jack 12/02/2017 12/05/2017 Smith 12/05/2017 12/08/2017 James 12/07/2017 12/09/2017
I want to assign job Start Date 12/04/2017 and End Date 12/06/2017
how to make filter query so i can find free employee on that date..?
The result of query is James 12/07/2017 --- 12/09/2017
thx