I hope that someone could help me. I know this:
SELECT A.IDTABLAA, B.NOMBRETABLAB
FROM TABLA_A A, TABLA_B B
WHERE A.IDTABLAA=B.IDTABLAB(+)
The WHERE here is equivalent to a LEFT OUTER JOIN, but I don't know what means when the (+) symbols is in other place, like this:
WHERE 1=1
AND A.IDA = B.IDB
AND A.TAB(+) = 'E'
What is the meaning of this?