I'm trying to update all records in one table GCI.EmployeeName to House after
I add a check to y/n field in table2 EmployeeInfo

UPDATE GCI.EmployeeName to house WHERE EmployeeInfo.EmployeeName,
EmployeeInfo.Terminated = 'y';

Thanks in Advance for any help

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200907/1