RE: Weird Behavior

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.

--
http://www.freelists.org/webpage/oracle-l