Try it, with your test data. You'll see the error message that SQL returns.
I figured that it would with more than 1 row. In this case they are always unique rows, but I think that I will put a TOP 1 clause in just to be sure.
Thanks again, Steve...
I'm new to your forum but have developed relational database software (Dataflex) for 30 years ... just making the jump to SQL and having to retrain my brain on how the concept differs
Mike