Feb 18 2005, 11:29 AM
I'm sending a query to a report. This query is based on 2 tables.
The error message is:
You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM class. Revise the SELECT statement of the subquery to request only one field.
What is this talking about? My query works perfectly in the query manager. I'd be happy to add the EXISTS reserved word, but I've never heard of this before. Any clues?
Feb 18 2005, 11:46 AM
What does your query look like,
and how many values does it return when you run it in by itself?
Feb 18 2005, 12:57 PM
Unfortunately, I've moved on in solving that problem and I am not getting the error message any more.
I was hoping that maybe someone would know what the Microsoft error message was talking about.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here