Outer join by (+)

There are two type to write select qurey left or right outer join

1.
from table1 left outer join table2 on (table1..column1=table2.column1)

2.
from table1, table2
where table1..column1=table2.column1(+)

Now I will add constant condation like table2.column2='AAAA'

it will be like this

1.
from table1 left outer join table2 on (table1..column1=table2.column1 and table2.column2='AAAA')

2.
from table1, table2
where table1..column1=table2.column1(+)
and table2.column2='AAAA'

but this is not left outer join becasue there is condition.

Question:
- How can I add this condition in secound case and still left outer
join?
- How can I make full outer join in secound case?
Received on Mon Dec 17 2007 - 02:01:43 CST