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!

SQL Syntax

Status
Not open for further replies.
klaidlaw

klaidlaw

Programmer
May 28, 2008
140
US
I am using Crystal Reports 2008 and I was wondering if there was a way to make crystal change the SQL syntax that it uses to join tables. Basically I want crystal to do a natural join instead of an inner join.

Thanks!
 
Sort by date Sort by votes
I'm not sure what joins are supported in the database expert for CR 2008, but you could use a natural join in a command.

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Gary Hnat
  • Locked
  • Question
Crystal SQL Code linking to partial database field entries
Replies
2
Views
362
Gary Hnat
Gary Hnat
dgillz
  • Locked
  • Question
Cannot connect to any ODBC datasource with MS SQL Server data in crystal
Replies
8
Views
658
LyleU
LyleU
PeaEssEl
  • Locked
  • Question
ASP.Net Crystal Reports connection to SQL Server through published website
Replies
2
Views
105
PeaEssEl
PeaEssEl
mwmark
  • Locked
  • Question
sql select syntax
Replies
2
Views
80
mwmark
mwmark
Luvsql
  • Locked
  • Question
Using dateadd(year, -1, @MyDate) in sp does not bring any data with Crystal but does with SQL
Replies
1
Views
94
briangriffin
briangriffin

Part and Inventory Search

Sponsor

Back
Top