Adam,
I'm afraid, we don't understand your problem in details, besides, it was quite a long time ago. Try to start another thread, but be as more specific, as you can be. It will help.
>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
If it's not broken, fix it until it is.
My Blog