var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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
Via some experiementation, we've found that this just behaves like an equi-join. Is there something else we should know about?
WHERE table1.key =+ table2.key
I think you want a "=*" or a "*=" . I dont think theres a "=+"
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.
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.