Here's one for the SQL experts

[Jack Callahan <jjcllhn@xxxxxxxxx>]

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 )
;