Klaus, (+) is deprecated OUTER JOIN syntax. It's not about allowing or not allowing NULL. O.Forwarder = F.ID(+) means include all rows from O even if there is no match in F. O.Forwarder(+) = F.ID means include all rows from F even if there is no match in O
Klaus-Werner Konrad wrote:
THIS is what I meant with 'never make an error / fault more than once
However you didn't qualify it in your first response. And regardless... In the context of marriage people don't marry the same person they divorced (the few cases that occur are below the noise level.) And due to the passage of time from one marriage to the next neither participant is the same person anyways. So it isn't the "same" mistake.
Matthew Faithfull, I could not resist copying your post to:http://www.tfmetalsreport.com/comment/339439#comment-339439 I believe you may like that site, and hope you join and contribute postings to it. Not my site by the way, but one I frequent.
Klaus-Werner Konrad wrote:
the OP asked for Report Builder 3.
I must have missed the version info there. Donno how many people here work with TeamDeveloper, its a new one on me (not really saying much).
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
