Toad World® Forums

Code Completion not working in correlated subqueries

Code Completion is a great time saver, but it doesn’t seem to work with correlated subqueries. Tables outside the subquery’s parentheses do not show up as options.

For an example, in the following SQL, the Employee table (aliased ‘E’) does not show up in the completion options in the subquery when I try to add the ‘E.Department_ID’ column to the WHERE clause)

SELECT Employee_ID FROM Employee E WHERE NOT EXISTS (SELECT 1 FROM Department D WHERE D.Department_ID = E.Department_ID);

**Is there a plan to add this to a future release?

**

**

Hi,

Many thanks for your soppurt. I have create issue TSS-626 for this. We will reply this if we have decision.

Thanks again,

Kelly