Limit rows returned in nested subquery

[Karin3]

This is the error msg:
.&quot;Subquery returned more than 1 value. This is illegal when the subquery follows =, !=, <, <= , >, >=, or
when the subquery is used as an expression.
Command has been aborted. &quot;
Example: I want a list of peoples phone numbers that fall in certain criteria, and a few people have more than one number that falls in the parameters. I only want one of these numbers per person and don't care which. How can I code this without another nested query or long case statement. There is a large number of records and performance is an issue.
Thank you in advance

 

[tlbroadbent]

Use &quot;Select Top 1 colA From tbl where ...&quot; The TOP predicate will limit the selection to one row. Terry

;-) I never worry about the future. It comes soon enough. -Albert Einstein

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm