Originally posted by Nathan Liebke
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.

Hi Nathan,

My database diver is Oracle and if i'm trying to run the same query in orcale then also its no accepting.
Creating a query u mean to create a view or something else

Thanx a lots
rupali