Archives of the TeradataForum

Message Posted: Wed, 07 Feb 2007 @ 14:23:27 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

From SQL Assistant HELP (F2).

     UPDATE employee
     SET PhoneNo = PhoneList.Number
     WHERE employee.Name =  PhoneList.Name ;

     DELETE FROM employee
     WHERE managers.DeptNo = employee.DeptNo
     AND managers.JobTitle IN ('Manager', 'Vice Pres')
     AND employee.YrsExp > managers.YrsExp;

	<Prev	Next>		<<First	<Prev	Next>	Last>>