Hi fellow Austinite.

I got it figure out. Thanks for pushing me back to the join. I tried the join before I made my post, but only got one record. Thinking my logic was wrong (expecting more matches) I went for the sub query. But in reality, there was only one match.

Thanks again,
Terrence