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?

What does your query look like,
and how many values does it return when you run it in by itself?

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.