sorry should have clarified... the code works when there is only one row returned in the outermost query.
--- Ronald J Kimball <[EMAIL PROTECTED]> wrote: > On Wed, Jul 30, 2003 at 08:51:34AM -0700, Adam Peterson wrote: > > hello, > > > > i'm having trouble with inner queries and am wondering if someone can > > offer help? i've confirmed that the actual sql is correct - or at > least it > > works from MS SQL Query Analyzer. the code also works when there is > only > > one row, but errors out when there is more than one row returned. > > If you mean that the inner query returns more than one row, that is the > problem. An inner query used in a comparison (=, <, etc.) must return > exactly one row. > > Ronald __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
