Here's one for the SQL experts

Couple of other ways to write the same query:

WITH mycte AS
(
SELECT account_id, MAX( date_of_call ) mydate
FROM callrptview
GROUP BY account_id
)
SELECT mycte.account_id, mycte.mydate ,
acctview.other-columns_from_acctview
FROM mycte
JOIN acctview USING ( account_id );


SELECT account_id,
SELECT MAX( date_of_call ) FROM callrptview
WHERE acctview.account_id = callrptview.account_id,
other_columns_from_acctview
FROM acctview
WHERE account_id EXISTS IN ( SELECT DISTINCT account_id FROM callrptview )
;