What is this "VALUE" doing 1

[meldennison]

Hello,
Thank you for taking the time to look at this. I am trying to document an enourmous SQL, and so far, it's been going well. However, I am not familiar with this part using "VALUE" for a field in a table. Would someone be able to explain what the "VALUE" returns in this query:
( select w.work_order_id, cc."VALUE" cat
from (select * from work_order_class_code where class_code_id = 63 ) cc,
work_order_control w
where w.funding_wo_indicator = 0
and w.company_id in ('04', '05', '10', '41', '49', '36', '48', '71', '92', '99') cn
and w.work_order_id = cc.work_order_id (+)
) bc

 

[gmmastros]

[tt]and w.work_order_id = cc.work_order_id [!](+)[/!][/tt]

The part highlighted in red is not valid Microsoft SQL Server syntax. I *think* this is Oracle syntax (indicating a left join), but cannot be sure. Regardless, you should probably ask your question is a forum related to your database engine to assure that you get the best advice possible.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[r937]

yes, it's oracle's non-ansi left outer join syntax

i believe "VALUE" is written that way, with delimiters (doublequote identifier delimiters happen to be ansi standard, by the way), because oracle probably thinks VALUE is a reserved word



r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[meldennison]

Thank you all so much. This explanation was very helpful.