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? 

 

here is the SQL.

 

Many thanks in advance   

 

Paul

 

SELECT
   worksorders."won",
    RO_WorksOrders."WONumber"
FROM
    worksorders
join RO_worksorders ON worksorders.won = RO_worksorders.wonumber
ORDER BY
    won