>Start simple. What does the following do?
>select scsaqty.saq_sku, sum(scsasld.sal_soldqty) TotSold ;
from scsaqty ;
left outer join scsasld ;
on scsaqty.saq_sku == scsasld.sal_sku ;
where between(scsasld.sal_solddate, ?dBgnDate, ?dEndDate) ;
group by scsaqty.saq_sku

This code will only give me sku's that that have been sold in the date range. The scsasld table will have an entry evertime a sku is sold. If a sku was never sold it would't have any entries in the scsasld file.

I need to have every sku from the scsaqty table and the total sold from the scsasld table even if none were sold durring the date range.

Pat