Crystal XI "+" sign shwoing up in an sql query

[CrystalLion]

I have a report in which a "+" sign has mysteriously appeared in parts of the sql query statement and the number 1 is being added to the tablename in the WHERE portion of the statement.

where["sql_fund1","fundid"="sql_fundrep1","fundid"[+]]...

the actual table name is sql_fund not sql_fund1.

Any thoughts would be helpful. (knowledgebases welcome)

Thanks,
L

 

[IanWaterman]

What database are you using. If Oracle then the syntax for a left outer join is the (+).

If you have added in the table sql_fund twice then Crystal default alias for the second entry of the table is sql_fund_1.

If this does not answer your question please show whole sql statement and tell us your DB.

Ian

 

[beltmanjr]

It does depend on your oracle version. I could be mistaken, but believe that from oracle 9 on the outer join no longer displays that way.

Other databases may have the same syntax still.

And Ian's remark of the alias is spot on

 

[buck149]

I think " sql_fund1" is an alias for your "sql_fund" table if you refer to the table twice in your query. "+" looks to me like an outer join though.