Old 7th December 2010, 09:30 AM
DanCroghan DanCroghan is offline
Junior Member
Join Date: Dec 2010
Posts: 20
Default Multi-Column update statement

Is it possible to update multiple columns from a subquery in an Update statement? Something like using a join or the "FROM" clause.

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
AV in execution of multi statement query Hans Hasenack nexusdb.public.support 2 23rd April 2009 11:23 PM
Insert or Update an AutoInc Column Ken Randall nexusdb.public.support.sql 1 6th August 2005 03:09 AM
Update Sql statement Ron Dolce nexusdb.public.support.sql 7 10th March 2004 08:20 PM
Multi-Statement SQL Philip Grace nexusdb.public.support.sql 6 10th March 2004 06:14 AM
Multi-Statement SQL Philip Grace nexusdb.public.support 3 10th March 2004 05:40 AM

All times are GMT +11. The time now is 08:16 AM.

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.