Using visual linking expert for complex left join

[EricVonSkip]

I want to do the following using visual linking expert:

select ....
from table1
left join table2 on table1.field1 = table2.field1
and table2.field2 = 123456

Is there a way to accomplish this in crystal without modifying the SQL directly and without using a WHERE which would force an inner join?

 

[LV]

You can do a left joint in the Visual Linking Expert and then put your filtering criteria (table2.field2 = 123456) into the report record selection formula, should be the same effect.

 

[EricVonSkip]

I cannot use filtering criteria because it will add table2.field2 = 123456 to the WHERE clause and force an inner join. It needs to be part of the join. Any other ideas?

 

[LV]

Looks like there is not such an option in Crystal. Need to modify a stored proc or view you report off.