Giving two tables:EmpCustEmpName, CustID, EmpIDApril, 1, AApril, 3, AApril, 2, ABruce, 4, BBruce, 5, BCarson, 2, CCarson, 1, CCarson, 3, CDavid, 2, DCustReviewCustID, ReviewDate, EmpID1, 01-05-06, A1, 12-13-05, C2, 07-04-04, A2, 05-21-03, C2, 04-02-03, D3, 10-10-02, A3, 02-01-06, C4, 01-01-06, B5, 12-12-04, BWrite a SQL statement that return each EmpName and LATEST ReviewDate. Result should look like this:EmpName, ReviewDateApril, 01-05-06Bruce, 01-01-06...

zanhsieh
Profile Answers by zanhsieh Questions by zanhsieh
Apr 7th, 2006
2
1701

Questions by zanhsieh answers by zanhsieh

Showing Answers 1 - 2 of 2 Answers

ratna_ponnapalli
Profile Answers by ratna_ponnapalli Questions by ratna_ponnapalli

Apr 11th, 2006

select a.empname,max(b.reviewdate) from empcust a,custreview b where a.custid=b.custid group by a.empname;

vishalb
Profile Answers by vishalb

Apr 27th, 2008

Tested!

SELECT E.EmpName, Max(C.Reviewdate) from
EmpCust E Join CustReview C on e.Empid=c.empid
group by c.empid, E.EmpName