LEFT JOIN ORACLE, is difirent LEFT JOIN POSTGRES?

I need help, my situation is the following, I transate SQL the ORACLE to POSTGRES, and i a big problem:

In oracle-->

SELECT *
 FROM esc_usuarios, esc_temas
WHERE esc_usuarios.id_usuario=1

      AND esc_usuarios.baja='N'
      AND esc_usuarios.id_tema=esc_temas.id_tema(+);

In postgres-->

 SELECT *
 FROM esc_usuarios uu LEFT JOIN esc_temas t ON (uu.id_tema=t.id_tema)) S1 WHERE esc_usuarios.id_usuario=1

      AND esc_usuarios.baja='N'

It's two sqls not same results. The data of tables is the same. Anybody help me?

Tahnsk. Received on Fri Jun 27 2003 - 07:41:38 CDT