Yes, I realize that the field does not exist in the sub table, that's why it was throwing me off that it would run.

Conceptually when I think of a subquery...

Thanks for the reply Micky. I actually tested the methods given and found the following.

Method 1 (Luis) seems to work the best in my situation. However, it...

You guys are awesome! Just please tell me you've had to deal with this before and that is why you came up with a solution so quickly :-P. ...

Sorry about that I went ahead and attached the index script as well as the actual execution plans. The first plan is hitting the smaller 16million row table while...