RE: Embedded SQL question - Expansion on the original question.

I would like to pose a situation which is an expansion of the original
question and know if this is possible from embedded sql.

I have a customer master file which I am only interested in two fields,
custno, and custname, but only those customers who are in a specific state.
I have a second file which has credit history on the customers, I am only
interested in the last statement date (which I will be using with the third
file) and I have a third file which has all the sales for the customers and
I am interested in knowing the total amount of sales for each customer.

So here is what I want: Custno, custname(from file 1), total sales (from
file 3)for customers in (whatever state you choose) and only for the period
greater than the last statement date(from file 2) and less than a date which
I will provide(parm passed to the program). Each customer could very likely
have a different statement date.

All this information should be written to a work file. If I had to include
the statement date, ending date as well, that would be fine I really would
not care.

Is this possible? Workable? Efficient?

I know that I could do a read and write from within a loop and get the
information as well and for me, probably would be easier....but I am hoping
to learn something new.






****************************************************************************
This transmission may contain information that is privileged,
Confidential and/or exempt from disclosure under applicable law.
If you are not the intended recipient, you are hereby notified that
any disclosure, copying, distribution, or use of the information
contained herein (including any reliance thereon) is STRICTLY
PROHIBITED. If you received this transmission in error, please
immediately contact the sender and destroy the material in its
entirety, whether in electronic or hard copy format. Thank you.
****************************************************************************