Ben, This won't cause your query to crash, but you need an outer join in the line: AND Incident."InActive:"(+) = 0 Otherwise, your queries intent of returning rows that don't have an Incident will not be met. Jason. -- //www.freelists.org/webpage/oracle-l