Demo

Employees

ename edepartment eperiod
John Shipment [2015-01-01,2017-01-01)
Sam Management [2015-01-01,2017-01-01)
Ann Shipment [2015-06-15,2018-01-01)
Joe Production [2015-01-01,2018-01-01)

Managers

mname mdepartment mperiod
Frank Production [2015-01-01,2018-01-01)
Frank Shipment [2015-01-01,2015-09-01)
Fred Shipment [2015-09-01,2018-01-01)
Sam Management [2016-01-01,2017-01-01)

Select query

Modify query

Results

No query was executed.