I have an issue wherein SQL won't return a result from a Select statement when there is only one result from a subquery.

The SQL statement in question is as follows;

SELECT * FROM Incidents WHERE (IncidentID IN SELECT IncidentID FROM Mitigation WHERE Mitigation_Activity = 'System/network configuration update')) ORDER BY IncidentID

If there is a more than one record in the Mitigation_Table, it works fine. However, if there is only one record in the Mitigation_Table, nothing is returned.

Oops...sorry, missed the open paren at the beginning of the subquery when I typed it in, but it's there when I run the query.

In your scenario, when only 1 row exsists in the Mitagation table, does the id that is returned from your subquery exist in Incidents?

Try running your subquery as just a query with 1 row in your Mitigation table, get the incidentID and run your original query and replace the subquery with the id that is returned as opposed to using your subquery.

"The one language all programmers understand is profanity."

Thanks...Wow...quick response. I was just logging in to say I'd resolved it and as it turns, out with pretty much the same solution.

Thanks again!

Glad you got it worked out.

"The one language all programmers understand is profanity."