Create a new column based on two event dates

hash9

I have two different tables

Table 1:

Event	Start	End
A	XX0	XX3
B	XX4	XX5
A	XX5	XX6

table 2:

Start/End	Date
XX0	1-Jan
XX1	5-Jan
XX2	20-Feb
XX3	3-Mar
XX4	4-Jun
XX5	4-Jul

I need to create a new column in table 2 i.e Event. Event A starts at XX0 & ends before XX3. So, it should look at the "date" (Table2) and assign the Event as "A" for the respective "Start/End"(Table2).

My output should look like this.

Start/End	Date	Event
XX0	1-Jan	A
XX1	5-Jan	A
XX2	20-Feb	A
XX3	3-Mar	A
XX4	4-Jun	B
XX5	4-Jul	A

Please help.

Joe_Mako

How about the attached, I made on of the operators < instead of <= and brought in any records that were not matched.

Sample jm.yxmd