Subject Query and problem with nulls

Try use explicit JOIN here:


...

FROM
  DOC_CORPO DC, DOC_TESTA DT

...