How to join two tables with date?

[rcandeo]

Hi, I have two tables like these:

Worker:

Name,

DateTime_Initial,

DateTime_Final,

Equipment

Production:

Equipment,

Date_Time,

Lot_Number

The first table has the names of the workers for each of the equipments in each date/time. It won´t happen to have more than a worker in the same equipment in the same date/time

The second table has the production of each equipment and it will have dozens of lines for each equipment by hour.

I need to have just one table linking the worker with the production, so I´ll know in the end wich is the production for each worker.

I´ve tried to use interval match but I don´t know how to put the equipment in the logic.

Best

Robson

[ronaldocarrijo]

Use this:

[rcandeo]

Hi, Look your table that didn´t work. The result is

Name	Equipment	Date_Time	DateTime_Initial	DateTime_Final	Lot_Number
A	X	01/01/2013 15:00:00	01/01/2013 12:00:00	01/01/2013 18:00:00	1
A	X	01/01/2013 19:10:00	01/01/2013 12:00:00	01/01/2013 18:00:00	2
B	X	01/01/2013 15:00:00	01/01/2013 18:00:01	01/01/2013 22:00:00	1
B	X	01/01/2013 19:10:00	01/01/2013 18:00:01	01/01/2013 22:00:00	2
C	Y	02/01/2013 13:40:01	02/01/2013 18:00:01	01/01/2013 22:00:00	4
C	Y	02/01/2013 18:30:01	02/01/2013 18:00:01	01/01/2013 22:00:00	3

This table have a duplication for lot number 1 and 2.

Lot number one should be with worker A only and lot two with worker B only.

[rcandeo]

anyone can try to help me please?

[ronaldocarrijo · Accepted solution]

Sorry, this right now:

[rcandeo]

Thank You Very Very Much!