Can this query be built?

Good day,

I have a table of sales quotas showing the quotas for each sales manager for each month. ie

MANAGER_ID QUOTA MONTH

KJR        8000  1-JUN-1999
KJR        6000  1-JUL-1999
KJR        7000  1-AUG-1999
SFH        5000  1-JUN-1999
SFH        6000  1-JUL-1999
SFH        8000  1-AUG-1999

The month column is a DATE type and I expect to use a BETWEEN clause to compare dates (BETWEEN '1-SEP-1998' AND '1-SEP-1999'). I need to query out the current month quotas plus the year to date quotas for each sales manager. ie (Current month is AUG-1999, Year to date is SEP-1998 to AUG-1999):

MANAGER_ID CURRENT YTD

KJR        7000    21000
SFH        8000    19000

I tried modifying a Paradox 7 QBE statement that *does* give me this answer into an equivalent SQL statement, but for the CURRENT column, it returns the first quota on the list. For the actual data, I have noticed that the Sales Managers are assigned a yearly quota and it is split evenly between all 12 months to generate the monthly quotas so it's not readily noticable unless I fake data like this.

Can this work?

Ken Rachynski Received on Thu Aug 05 1999 - 10:38:30 CDT