What is "oj"?

[SarahMS]

Can someone tell me what the OJ in in the joining claus of the sql query passed from CR is? I have a report that is doubling some fields. If I past the sql query into query analyzer, it does the same thing, but if I take the oj off, works fine. What in the world is it?

Thanks,
Sarah

 

[rosemaryl]

OJ means outer join.

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[kenhamady]

Are you using a less common flavor of SQL? Crystal defaults to using this {oj} style syntax when it doesn't recognize the type of SQL to use. There are registry settings that you can change if you know what type of SQL it should be using. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com