>I think you'd have to do something like this:
>
>select customer, sum(invoices) from ;
>(select Customer, count(InvNum) as Invoices;
> from ActiveInvoices;
> group by Customer;
>union select Customer, count(InvNum) as Invoices;
> from HistInvoices;
> group by Customer;
> order by Customer)
>group by customer
That type of query is not supported in VFP. It would be cool if it did, though.
What would that work in? I tried it in SQL 7 and it didn't work either.
Insanity: Doing the same thing over and over and expecting different results.