Paste Description for Untitled
SELECT ACCOUNTS.COLLECTOR_ID,
ACCOUNTS.ACCT_ID,
ACCOUNTS.ACCT_COMMENT_DATE,
FROM ACCOUNTS
JOIN INVOICES ON
(INVOICES.COLLECTOR_ID = ACCOUNTS.COLLECTOR_ID
AND INVOICES.ACCT_ID = ACCOUNTS.ACCT_ID)
WHERE ACCOUNTS.ACCT_DUPLICATE = 0
GROUP BY COLLECTOR_ID, ACCT_ID
- Untitled
- Tuesday, August 1st, 2006 at 1:41:01pm MDT
- SELECT INVOICES.ACCT_ID
- FROM INVOICES, ACCOUNTS
- WHERE INVOICES.COLLECTOR_ID = 1
- AND SUM(INVOICES.INV_31_60) < (SELECT SUM(INV_31_60)
- FROM INVOICES
- WHERE COLLECTOR_ID = 1
- AND ACCT_ID = 'OM101736' LIMIT 0, 1)
- AND INVOICES.INV_31_60 > 25
- AND INVOICES.INV_61_90 = 0
- AND INVOICES.INV_91 = 0
- AND INVOICES.COLLECTOR_ID = ACCOUNTS.COLLECTOR_ID
- AND INVOICES.ACCT_ID = ACCOUNTS.ACCT_ID
- ORDER BY ACCOUNTS.ACCT_COMMENT_DATE, INVOICES.INV_31_60 DESC
- LIMIT 0, 1;
advertising
Update the Post
Either update this post and resubmit it with changes, or make a new post.
You may also comment on this post.
Please note that information posted here will expire by default in one month. If you do not want it to expire, please set the expiry time above. If it is set to expire, web search engines will not be allowed to index it prior to it expiring. Items that are not marked to expire will be indexable by search engines. Be careful with your passwords. All illegal activities will be reported and any information will be handed over to the authorities, so be good.