I usually end up writing a small routine to do what I could do with one update statement. I have a Client table and an HomeVisit table. I want to update the Client table with the latest HomeVisit date, so I try to write my command like this: update ClientMaster set LastHomeVisit = (max(t1.VisitDate)) from HomeVisit t1, Client t2 where t1.ClientID=t2.ClientID I get a message like 'Illegal Select Function' I know this can be done simply, I just never know how. Can someone tell me what the correct syntax is? Thanks, Patti
