Home » SQL & PL/SQL » SQL & PL/SQL » outer join
outer join [message #19747] Fri, 05 April 2002 10:25 Go to next message
LI810
Messages: 25
Registered: February 2002
Junior Member
Please help.

I have this outer join clause in where clause of the SELECT .
When the SELECT statement is executed the returned result have the population of equal join , not the outer join as I expected.

" and (f.brn_i || ' ' || f.ACC_FA_I) = fa.FA_I(+)"

What could be wrong with the query?
Re: outer join [message #19754 is a reply to message #19747] Sat, 06 April 2002 11:15 Go to previous message
Su
Messages: 154
Registered: April 2002
Senior Member
Since your code is not clear, I am not sure whether it is applicable to your query. Normally when we use two columns in a join, they should be identical in their type. Both can be of primary key and foreign key also, respectively. It seems, here your code to compare two values may not be exactly what you are assuming they have to be. First make sure, the concatenated values comparable to the value of righthand side operand. Just to be sure of, write a simple sql statement to retrieve the combination (f.brn_i||''||f.ACC_FA_I) and find out whether they are as you are assuming them. Make sure, it is not adding any extra spaces between f.brn_i and f.ACC_FA_I concatenation and whethere it is comparable to the value of fa.FA_I.
It would be better to clarify if the code is given in more details.

Check it out.
Good luck :)
Previous Topic: debugging stored procedure
Next Topic: Difference between Varchar dates
Goto Forum:
  


Current Time: Mon Mar 18 23:55:13 CDT 2024