Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: Strange syntax in WHERE clause

    We recently came across some strange syntax, and we're wondering if there's something happening beyond what we've discovered.

    Bascially, the table relationship is indicated as

    Code:
    WHERE table1.key =+ table2.key
    Via some experiementation, we've found that this just behaves like an equi-join. Is there something else we should know about?

    Thanks,
    Chuck

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443

    Strange syntax

    I think you want a "=*" or a "*=" . I dont think theres a "=+"

    Vishi

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    probably done by some Oracle developer. This used to work on older versions of Oracle for OUTER JOIN. The strange thing is, that it works on Sybase. Perhaps some engineer at Sybase added to make Sybase migration easier or vice-versa.

  4. #4
    Join Date
    Sep 2005
    Posts
    4
    This has got nothing to do with joins. Its got to do with the sign of the value.

    In the above comparison table1.key is compared against +(table2.key). just put a -ve sign and you will get no result.

    Thyagarajan Delli.
    DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •