How to have unequal joins in Btrieve tables

[balajee]

Hi<br><br>I have two tables, on &quot;inventory&quot; and another &quot;sales&quot;. both are indexed on part no. &quot;Sales&quot; is also indexed on date. I would like to get a list of parts for period where there has been sale and those who have not been sold. I am using 3 parameters as &quot;startdate&quot;, &quot;enddate&quot; and a &quot;string&quot; for part description.<br><br>Can somebody tell me how do I get this? I think i need to have an unequal join for these tablesbut do not know how to do it. Because when I try to go to options in visual linking, the various optins for joins are disbaled.<br><br>Thanks<br><br>Balajee

 

[MalcolmW]

It sounds like you need an equal join.&nbsp;&nbsp;Why would you use an unequal join?&nbsp;&nbsp;However, since you are using a non SQL database, Crystal by default chooses only a left outer join.&nbsp;&nbsp;This is why you have no options for linking.<br>Check out linking in the help file for more info on this.<br>Understanding linking is a key tool in using Crystal Reports, so it is worth some serious study.