Ralph
I agree. Didn't I say that I don't think it can be done in 1 SQL, and how you've outlined is what I was thinking of.
OTOH I assumed this technique would be a real nut-ache.
>Terry,
>Why does this have to be in one SQL statement? It seems to me that you would be better off segmenting each part of the query into seperate SQL's and then use a program to set relations and produce a summation report.
>Not only would it be easier to follow a year from now, but if any changes to 'assumptions' need to be made it would be much easier to do so.
>
>It would also be much less of a headache to develop :)
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.