UPDATE STUDENTSET FNAME =(SELECT EFNAME FROM ETABLEWHERE STUDENT.ERMID=ETABLE.EPERMID);
Is there any way to do more than one column at a time ?thanks,DB