Which stage for matching a date value in a range

[pompano]

I'm having trouble figuring out which stage to use for this scenario.

I have two equally large data source tables. I need to take records from table A where a date vaule in A falls between a start and end date in table B.

The two tables have no columns in common to use for an equi-join.

I can't use a lookup here since I need to keep going after the first lookup.

I also need to keep a list of the records from A that fall out and have no matches in the data range of B.

This is not a mainframe project.


Any suggestions?

[ray.wurlod]

You have not specified the logic. There appears to be no way to solve the problem as posed, as there is no relationship between the two tables. Even if I can select a row - or several rows - in the date range from table B, how does that tell me which row(s) to select from table A?