Re: Transferring information from a field in one table to a field in another table using informix-sql

Craig Kickel (ckickel@cyberhighway.net) wrote: : I suspect you're close. Try something like: : UPDATE addemp : SET setteyr1 = (SELECT tearn_y FROM wrkemployee : WHERE wrkemployee.taxyr = 1995 : AND wrkemployee.empl_no = addemp.empl_no); : --Craig And don't forget the second pair of parentheses. UPDATE addemp SET setteyr1 = ((SELECT tearn_y FROM wrkemployee WHERE wrkemployee.taxyr = 1995 AND wrkemployee.empl_no = addemp.empl_no)); -- Zdeno Miklas SOFTEC spol. s r. o. e-mail: ash@softec.sk Kutuzovova 23 phone : 42-7-273805 ext.128 831 03 Bratislava fax : 42-7-272537 SLOVAKIA