Selecting all records based on initial record's date range

[koolskins]

CR10 running under an Informix DB. I need to select all purchase order supplements for a given vendor where at least one supplement was issued during a given date range. The primary supplement table has a supp_id and a po_id for each record. I built a report with the primary supplement table selected twice. I then selected from the first instance of the table based on the date range and then I'm reporting from the second instance of the report. The two tables are joined at the po_id column level but even so, I am still only getting supplement records where the date criteria matches????

RW

 

[lbass]

Change the join to a left join FROM the table with the selected date range TO the alias table.

-LB

 

[koolskins]

Thanks, that seems to have fixed the problem.

RW