I have a Crystal Report written in 2002 that uses a ttx data source. The left outer join is noted in the sql query as "*=". I have just upgraded to MSSQL 2016 and it does not recognize *=. How do I update the outer join without completely rewriting the report?
(Example: AND BRKRASGN.CLEARING_BROKER*=CLBROKER.BROKER_CODE )
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.