I'm not Maurice but I'm happy to try and help if I can.


If at all possible I would strongly recommend putting a join like this into a query that runs on the server and then use the query as the basis of your crystal report. The reason being that if Crystal attempts a join like that it will have to drag down all records from both tables which will get very ugly.

Also, I think Crystal uses Length and not Len and I'm not 100% sure that it accepts CROSS JOIN but I guess that would depend on which database driver you use. What database driver are you using?

If you are unable to set up a query on the server I think the following might work:

SELECT
table1.field1, table2.field2
FROM
table1, table2
WHERE
LEFT(table1.field1, 3) = LEFT(table2.field2, 3) and LENGTH(table1.field1) > 0

But I think creating a query will give you a much better result.

Hope this helps,

Nathan.