The Query Builder is not qualifying columns which can cause an error when running some queries.
For example,
SELECT emp_id
FROM department, employee
WHERE (PERSON_ID = 69139)
AND (department.emp_id = employee.emp_id)
Because emp_id exists on both tables, an error results because emp_id is ambiguously.
1. Go to Tools | Options | Database | Query Builder
2. On the right side check the following:
a. Use fully qualified column names
b. Use fully qualified object names
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center