Print Page | Close Window

SQL Statement wont work in Crystal

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9841
Printed Date: 19 May 2024 at 2:44am


Topic: SQL Statement wont work in Crystal
Posted By: paul_birm
Subject: SQL Statement wont work in Crystal
Date Posted: 28 Apr 2010 at 5:17am
Hi Guys
 
I have an SQL Statement that simply reports 3 columns of data from 2 different data tables - there is a SQL JOIN in there.
 
I run the SQL and it works fine.
 
I run the Crystal reports SQL and it doenst join!!!!
 
What am I doing wrong?  CryCryCry
 
here is the SQL.
 
Many thanks in advance Clap Clap Clap
 
Paul
 
SELECT
   worksorders."won",
    RO_WorksOrders."WONumber"
FROM
    worksorders
join RO_worksorders ON worksorders.won = RO_worksorders.wonumber
ORDER BY
    won


-------------
Paul
Birmingham
England
{A friend in need is a pain in the a***}


Print Page | Close Window