Nested Select subquery

• Ads-812946

  SSC-Addicted

  Points: 432

  More actions

  October 20, 2008 at 8:33 am

  #200148

  Hi (again)

  I have modified a piece of code (suggested by Chris) that works on its own as a subquery but I am getting the following error;

  Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

  I have adapted the query as follows;

  SALES.ID,

  (SELECT TOP 1 PRODUCT.INFO FROM (SELECT TOP 2 * FROM PRODUCTS WHERE PRODUCTS.ID = SALES.ID AND DESC LIKE 'FLAG SET TO%' ORDER BY DATE DESC) d ORDER BY DATE)

  FROM SALES

  Any ideas on how I can combat this problem or use "EXISTS"?

  Thanks

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  October 20, 2008 at 10:48 am

  #887230

  You really should keep this in the same thread: http://www.sqlservercentral.com/Forums/Topic588510-1291-1.aspx

  Have you looked at the recent suggestions given there?

  😎