>SELECT A.*, P.PName, M.ref_MR ;
>FROM A, P, M ;
>WHERE ref_RefNo = RefNo AND ;
> A.ByDr = P.PNumber(+) ;
> ORDER BY GLAcct, PatNme
>
>
>Ok what the heck is the ( + ) doing in this statement?
If I remember correctly is an outer join, old syntax.
[Update] Just googled [oracle outer join syntax] and the first find confirms that my memory was not wrong (surprise!)
http://www.dba-oracle.com/tips_oracle_left_outer_join.htm[/Update]
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges