any fields you add from the secondary table must also be specified in the
group by clause.
-sjl
"James H. H. Lampert" wrote in message
news:mailman.16593.1361582241.10847.midrange-l@xxxxxxxxxxxx...
Given this SQL (the names have been changed to protect the innocent):
SELECT CALLRECVIEW.ACCOUNT_ID, MAX(DATE_OF_CALL)
FROM ACCTVIEW, CALLRPTVIEW
WHERE ACCTVIEW.ACCOUNT_ID = CALLRECVIEW.ACCOUNT_ID
GROUP BY CALLRECVIEW.ACCOUNT_ID
we (and this was just handed to me, the first I'd heard of it) seem
unable to add any fields from ACCTVIEW to the SELECT.
I'm about to suggest changing it to "FROM ACCTVIEW JOIN CALLRECVIEW ON
ACCTVIEW.ACCOUNT_ID = CALLRECVIEW.ACCOUNT_ID," but would that make any
difference.
What are we doing wrong?
--
JHHL
