Hi Rich, I appreciated the replies you and Nadia sent back in March, and sorry for not getting back before this, but I've been sidetracked. The solution you provided does work, however, what I failed to state is that I don't wish to perform this for a single ZipCode, but for a whole table (query) of zips. In VFP this wouldn't be a problem, but I'm populating a table for a webpage, and to have the SELECT's below run for each line (record) would be very load intensive. Thus, I was looking for a query that would do it all in one server construct. If you have any further ideas, I'd be glad to try them out.

Adam


>I'm reading your requirements differently from the way Nadya did - and I've been wrong before doing that. I think you want to know how many orders were received for each zip code and how many deliveries were made into each zip code. FWIW, here's my solution
>

>SELECT o.deliverydate,o.zip,00001 AS oZipCount,00000 as bZipCount;
>  FROM [OrderData] o;
>  WHERE o.deliverydate >= ldDate;
>UNION ALL;
>SELECT b.billingdate,b.zip,00000,00001;
>  FROM [BillingInfo] b;
>  WHERE b.billingdate >= ldDate;
>INTO CURSOR curFirst
>
>SELECT deliverydate,zip,SUM(oZipCount),SUM(bZipCount);
>  FROM curFirst;
>  GROUP BY 1,2
>

>
>Hope this is what you needed.......Rich