table join

I am trying to create a business view in jde 9.1. The view would be a join of two tables with dates in the secondary table. The dates arent in the primary table and would like to base my data selection on the dates from secondary table. I tried join type as simple and then also tried left outer but neither of it generates the output that I was looking for which would be all the records from primary table which pass the date filters from the secondary table. But what I get is all records from secondary table. I