Usually, if you need to limit results in a subselect, you either want to use a "DISTINCT" or a "TOP 1" in your subquery.  Your statement might look like:

Select...