Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Amaranthix
Starting Member
7 Posts |
 Posted - 2007-12-20 : 16:46:55
|
| We were just sent some code from a client to look over, and we can't figure out what this symbol means.(+)We see it after certain select statements. If someone can shed some light on this I'd appreciate it. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-20 : 16:48:42
|
Is it T-SQL? The Microsoft SQL Server query language dialect?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
Amaranthix
Starting Member
7 Posts |
Posted - 2007-12-20 : 17:01:05
|
| I'm assuming it is. We've never dealt with anything else. I've found another instance of it in a giant "where" statementand ol.salesrep_id = sr1.salesrep_id(+)and oh.org_id = sr.org_id(+)and ol.salesrep_id = sr1.salesrep_id(+)Someone here suggested it might be oracle code, which I'm unfamiliar with.The majority of the other "where" statements don't include it on the end. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-20 : 17:15:18
|
| They are not t-sql, that's for sure. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-20 : 17:23:15
|
Try www.dbforums.com
E 12°55'05.25"N 56°04'39.16" |
|
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2007-12-20 : 18:57:00
|
| It's Oracle's outer join syntax.Same asselect blah from ol left outer join sr1 on ( ol.salesrep_id = sr1.salesrep_id and ol.salesrep_id = sr1.salesrep_id) |
|
|
|
Amaranthix
Starting Member
7 Posts |
Posted - 2007-12-21 : 09:37:31
|
| Great, thank you very much. I tried to google it before posting here but I couldn't find any results. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-12-21 : 20:16:05
|
that syntax is perverse.
elsasoft.org |
|
|
|
|
|
|
(+)