Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Deprecated Left OuterJoin

Status
Not open for further replies.
egodette

egodette

Technical User
Jun 12, 2002
222
0
0
US
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 )

thanks...

 
Status
Not open for further replies.

Similar threads

VE
  • Locked
  • Question
left outer join not working 1
Replies
5
Views
51
VE
VE
MarkB1000
  • Locked
  • Question
Split String, Delete to the Left of the Splitter
Replies
6
Views
54
Madawc
Madawc
Luvsql
  • Locked
  • Question
Left Outer Joins with Restrictions on Outer Table
Replies
1
Views
31
IanWaterman
IanWaterman
tcbc
  • Locked
  • Question
truncate left 33 characters of field and use as parameter
Replies
6
Views
52
CsaintAZ
CsaintAZ
TripperDay
  • Locked
  • Question
Using LEFT or SUBSTRING in Add Command?
Replies
5
Views
56
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top