I have three databases. FFINV, MasterD and MasterF. FFINV points to MasterD and MasterF using a key field and a left join.

 

in the report, if I select just off a billcode field, I get MasterF and MasterD information. If I add that I want all records from MasterF that fall between 05/01/2012 and 05/31/2012, I only get MasterF records,as would be expected. However, i need to get records from both MasterF and MasterD that fall into that date range. I cant seem to come up with the logic to get that accomplished in the Select Expert.  I can get one or the other, but not both.

 

I am using version 10 of Crystal Reports