Select DISTINCT(cust_nbr), MAX(cmplt_dt)
FROM sales_datebook, ui_results_db.emp1
where cust_nbr IS NOT NULL
AND cmplt_dt > '05/14/2006'
AND emp_nbr = emp1
group by cust_nbr, cmplt_dt
The above query results in the above list, which is the correct list.
However, my need is for only the LAST or LATEST date that the account was called, not all dates.
The DISTRICT() and MAX() seem to have no effect...+
Can someone help? Thanks!!!~bat