Very Very Urgent Issue On crystal Reports

[Maurice Sanders]

Hi,

Use a query like
SELECT
table1.field1, table2.field2
FROM
table1 CROSS JOIN table2
WHERE
LEFT(field1, 3) = LEFT(field2, 3) and LEN(field1) > 0

I put LEN(...) to the where clause to avoid records with empty values for those fields.

Be aware that you can get double records because you do not want to link the tables via a key value.


Regards,

Maurice