Posted by Ted on 08/21/06 19:37

boa wrote:
> * 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
>
Nothing changes. The same error is generated.

Thanks

Ted

[Back to original message]