Crystal Reports & Native Pervasive..

[antonjw]

Can somebody provide some insight into the following problem?

I am trying to do the equivalent of a left outer join, but of course in native mode the default in Crystal is an equal join.

I want to join two tables and pull all data from the left table but data from the right table where my linked fields match.

Thanks in advance for any help.

 

[TomKane]

What version of Pervasive are you using? I found that to do a left outer join on version 7 I had to use (+) as below:

SELECT * from FILEA, FILEB WHERE FILEA.Code = FILEB.Code (+)

Best of luck...