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 Mike Lewis 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
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
141
VE
VE
MarkB1000
  • Locked
  • Question
Split String, Delete to the Left of the Splitter
Replies
6
Views
107
Madawc
Madawc
Luvsql
  • Locked
  • Question
Left Outer Joins with Restrictions on Outer Table
Replies
1
Views
65
IanWaterman
IanWaterman
tcbc
  • Locked
  • Question
truncate left 33 characters of field and use as parameter
Replies
6
Views
94
CsaintAZ
CsaintAZ
TripperDay
  • Locked
  • Question
Using LEFT or SUBSTRING in Add Command?
Replies
5
Views
103
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top