Hi all,

I am new at crystal and I got the task to create a report includes two tables. But I have a problem to link these two tables correctly. I need a sql-statement like this:

SELECT field1, field2, ... FROM table1, table2 WHERE (table1.field1=table2.field1 OR table1.field1=table2.field2) AND table1.field3=0

With the database-assistent I can link the fields but get only AND-bindings in the final sql-statement of crystal. Is there any possibility to get the required sql-statement?

Thanks for your answer. That works fine for using it with the report-generator. But if I want to use this report with the crystal-server as an automatic action, I got the message that a table couldn't be found. My report includes only the custom command.

We use an older version of the crystal-server (think it was 6), but a newer version of the generator (10). Could this be a compatibility problem?