(+) and @variable in SQL query?

[Seeker]

Not sure if this is the right place to ask, but Google strips out non alpha
characters when doing a search...

I'm looking at an SQL query that the wife just emailed to me... the WHERE
clause has a couple of items that I don't recognize...


WHERE (SR_SERV_REQ_SI.DOCUMENT_NUMBER(+) = SR_SERV_REQ.DOCUMENT_NUMBER) AND
(SR_SERV_REQ.ORDER_NUMBER = @variable('Acc #')

....just wondering what the (+) means and what the @variable('Acc #') refers
to.

Thanks!

 

[MGFoster]

Not sure if this is the right place to ask, but Google strips out non alpha
characters when doing a search...

I'm looking at an SQL query that the wife just emailed to me... the WHERE
clause has a couple of items that I don't recognize...


WHERE (SR_SERV_REQ_SI.DOCUMENT_NUMBER(+) = SR_SERV_REQ.DOCUMENT_NUMBER) AND
(SR_SERV_REQ.ORDER_NUMBER = @variable('Acc #')

...just wondering what the (+) means and what the @variable('Acc #') refers
to.

What dialect of SQL is this? It doesn't look like Microsoft Access
(JET) SQL nor Microsoft SQL Server SQL.

 

[John Vinson]

What dialect of SQL is this? It doesn't look like Microsoft Access
(JET) SQL nor Microsoft SQL Server SQL.

It's how ORACLE used to handle Outer Joins.

 

[Seeker]

What dialect of SQL is this? It doesn't look like Microsoft Access
(JET) SQL nor Microsoft SQL Server SQL.

All I know is that it has something to do with Crystal Reports (which I've
never touched).