Posted by boa on 08/21/06 18:44

* Ted wrote, On 21.08.2006 17:28:
> I constructed the following SQL statement by studying the example on
> page 392 in Itzik Ben Gan et al.'s "Inside Microsoft SQL Server 2005:
> T-SQL Querying"
>
> SELECT s_supplier_code, s_supplier_name FROM suppliers AS S1
> WHERE s_supplier_code =
> (
> SELECT TOP(1) * FROM suppliers AS S2
> WHERE S2.s_supplier_code = S1.s_supplier_code
> ORDER BY s_supplier_name
> )
> ;
>
> However, it generates the following error.
>
> Msg 116, Level 16, State 1, Line 4
> Only one expression can be specified in the select list when the
> subquery is not introduced with EXISTS.


What happens if you replace
select top(1) *
with this?
select top(1) some_column_name



Boa
[snip]

[Back to original message]