Then remove the LEFT OUTER part.
>>Start simple. What does the following do?
>>select scsaqty.saq_sku, sum(scsasld.sal_soldqty) TotSold ;
> from scsaqty ;
> 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
Mark McCasland
Midlothian, TX USA