Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

updating columns question

2 views
Skip to first unread message

Don Bowen

unread,
Jul 21, 2008, 12:18:11 AM7/21/08
to
right now, I'm updating columns one at a time, like so...

UPDATE STUDENT
SET FNAME =
(SELECT EFNAME FROM ETABLE
WHERE STUDENT.ERMID=ETABLE.EPERMID);

Is there any way to do more than one column at a time ?
thanks,
DB

0 new messages