On Mon, 20 May 2002 21:36:18 -0400, Dan Stein wrote:
>Update courses
>Set courses.from_date=course_crosslink.Course_date
>Where courses.course_ID=course.crosslink.course_ID
Dan,
A multi-table update is not in the SQL standard, so each DBMS
implementation may have its own way to do a multi-table update,
which was a . In DB2 and R:Base, it would go something like:
UPDATE courses
SET from_date = c2.course_date
FROM courses c1, course_crosslink c2
WHERE (c1.courseid = c2.courseid)
Sorry, I don't know the MS SQL Server syntax.
Bill
But
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
