Editing SQL Query in Crystal 10

[DiggerDog]

Hi
Is it possible to edit the SQL query in 10 like you can in 8.5. I'm using the database expert to join 2 tables and want to join on 2 fields from the same table i.e.

Join tableA to TableB
Where TableA.Field1 = TAbleB.Field1 or
TableA.Field1 = TAbleB.Field2

In CR 8.5 I can simply click "Show SQL Query" and insert the Or part of the join - I am unable to do this in CR 10.

Is there any way around this

thanks

 

[lbass]

I think you would have to use "Add command" as your datasource, and enter the entire query there.

-LB

 

[DiggerDog]

thanks IBass

works a treat