SQL Query doubt

[rsrinivasan]

Hi,
Good Morning To All..

I have doubt in my query..

My Query is,

select * from table1,table2, table3..
where table1.field=table2.field
and table2.field(+)=table3.field(+).
(my Query is very big. So i give only the model. Sorry for this...)

My query is looking like above..
I cant realize the (+) symbol in my Query. What is this?

Thanks,

Srinivasan r.

[debasisdas]

R u sure the + symbol is on both the sides of the = operator.

[rsrinivasan]

R u sure the + symbol is on both the sides of the = operator.

Hi,

No. It only on the right side of "=" operator.

Thanks,

Srinivasan r.

[debasisdas]

The + symbol is called the predicate or the outer join operator.

+ (predicate) can be specified only on one side.

The table on which the predicate is specified symbolises to select only matching records from that table and also non-matching from other table.

[debasisdas]

Specifying + to symbolise outer join is oracle 8 syntax.
It is still supported in 10g is only for backward compartability.

If the predicate is specified on the left side ---it is right outer join
If the predicate is specified on the right side ---it is left outer join.

[rsrinivasan]

Specifying + to symbolise outer join is oracle 8 syntax.
It is still supported in 10g is only for backward compartability.

If the predicate is specified on the left side ---it is right outer join
If the predicate is specified on the right side ---it is left outer join.

Ok.. Thanks....

[debasisdas]

You are most welcome.

Feel free to post your doubts/queries in the forum,

But first give a try from your side

and if possible specifty what u have tried to solve the question.

In that case it will be easier for the EXPERTS of the forum in understanding and solving your problem

debasisdas

[prakhar gupta]

Hi,
Good Morning To All..

I have doubt in my query..

My Query is,

select * from table1,table2, table3..
where table1.field=table2.field
and table2.field(+)=table3.field(+).
(my Query is very big. So i give only the model. Sorry for this...)

My query is looking like above..
I cant realize the (+) symbol in my Query. What is this?

Thanks,

Srinivasan r.

The (+) symbol shows the syntax for OUTER JOIN. so whenever we are doing an outer join we use this operator...