IntervalMatch

[MK_QSL]

I have two tables

Machine Maintenance Due to Fault

MachineMaintenance:
Load * Inline
[
Machine,Problem Start,          Problem End
M1,        12/06/2014 12:00,    12/06/2014 14:00
M2,        13/06/2014 10:00,    13/06/2014 13:00
M3,        14/06/2014 14:00,    14/06/2014 14:30
];

Machine Work

MachineWork:
Load * Inline
[
Machine,   WorkOrder, From,                To
M1,        100,       12/06/2014 10:00,    12/06/2014 18:00
M1,        101,       12/06/2014 20:00,    13/06/2014 22:00
M2,        102,       13/06/2014 08:00,    13/06/2014 15:55
M2,        103,       13/06/2014 16:00,    14/06/2014 23:55
M3,        104,       14/06/2014 13:00,    14/06/2014 16:00
M3,        105,       14/06/2014 18:00,    14/06/2014 20:00
];

I need to know the below output which shows against which work order, the machine has got fault.

The output table looks like below…

Machine	Problem Start	Problem End	WorkOrder
M1	12/06/2014 12:00	12/06/2014 14:00	100
M2	13/06/2014 10:00	13/06/2014 13:00	102
M3	14/06/2014 14:00	14/06/2014 14:30	104

Appreciate your quick response

[MK_QSL]

Sorted out myself...