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
