Multi-query in Query Builder gives "Toad for Data Analyst: ORA-01427: single-row subquery returns (4286091)

When I run a multi-query that I created in the Query Builder I get the following error in the message column of the Results pane.

"Toad for Data Analyst: ORA-01427: single-row subquery returns more than one row."

For example running the following generated by the Query Builder will result in ORA-01427

SELECT d.location_ID
FROM departments d
WHERE d.department_ID = (SELECT e.department_id
FROM employees e
WHERE e.manager_ID = 100)

The WHERE clause from the main SELECT statement cannot use "=" operator for a multi-query. Because the sub SELECT statement returns multiple rows, you must use either ANY, ALL, IN, or NOT IN to specify the values to compare in the main WHERE clause.

For example, the example query must be

SELECT d.location_ID
FROM departments d
WHERE d.department_ID IN (SELECT e.department_id
FROM employees e
WHERE e.manager_ID = 100)

In the Query Builder adjust the WHERE clause with the appropiate operator.

Note: Query Builder will not check for syntax convention please make sure you consult a PL/SQL text for the appropiate syntax to multi-queries.