(+) and @variable in SQL query?

  • Thread starter Thread starter Seeker
  • Start date Start date
S

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!
 
Seeker said:
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.
Click to expand...

What dialect of SQL is this? It doesn't look like Microsoft Access
(JET) SQL nor Microsoft SQL Server SQL.
 
MGFoster said:
What dialect of SQL is this? It doesn't look like Microsoft Access
(JET) SQL nor Microsoft SQL Server SQL.
Click to expand...

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