Unusual code 2

[xxing]

Hi I have been given stored procs that has some unusual code I have never seen before.

SELECT
o1.name,
o2.name,
p.firstname + ' ' + p.surname,
p.firstname + ' ' + p.surname + ', ' + o2.name,
d.decision_id,
rr.decision_id
FROM 
{
oj 
((((DECISION d
INNER JOIN PERSON p ON d.NOMINATED_PERSON_ID=p.PERSON_ID) 
INNER JOIN JOB j ON d.JOB_ID=j.JOBID) 
INNER JOIN ORGANISATION o1 ON j.ORGANISATION_ID=o1.ORGANISATION_ID)
INNER JOIN ORGANISATION o2 ON d.ORGANISATION_ID=o2.ORGANISATION_ID) 
LEFT OUTER JOIN REWORK_REQUEST rr ON d.DECISION_ID=rr.DECISION_ID 
}

What does the { oj in the from clause mean?

Thank you for your help

Regards
Mark

 

[RyanEK]

Hi

Its an escape sequence. See here SQL Escape Sequences

Ryan

 

[SQLSister]

I read that article but I can't understand why they would be needed? what do they get you that the joins themselves wouldn't give you?

"NOTHING is more important in a database than integrity." ESquared

 

[xxing]

Thanks for the explanation RyanEk