updating columns question

Thread View: borland.public.interbase.sql

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Don Bowen Mon, 21 Jul 2008 04:18

#186

Author: Don Bowen
Date: Mon, 21 Jul 2008 04:18

10 lines
1204 bytes

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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads