Luis Rodriguez wrote:
You are using a "GROUP BY", so any columns that aren't being used in a
aggregate (?) function, such as count() or sum() must appear in the SELECT
and in the GROUP BY as well. Something like:
SELECT ACCTVIEW.COLUMN1, CALLRECVIEW.ACCOUNT_ID, MAX(DATE_OF_CALL)
FROM ACCTVIEW, CALLRPTVIEW
WHERE ACCTVIEW.ACCOUNT_ID = CALLRECVIEW.ACCOUNT_ID
GROUP BY ACCTVIEW.COLUMN1, CALLRECVIEW.ACCOUNT_ID
and Tommy Holden and "sjl" ("TheBorg") said substantially the same thing.
Thanks. I've passed the information on to those directly involved.
Once you'd told me what was wrong, I also found it in the Dummies book,
and made a copy of the relevant page.
It seems like whenever SQL is involved, my default state seems to be
utter bewilderment.
--
JHHL
