Updating Data - 2nd Query

[Alan Payne]

First of all I don't normally use SQL, so please excuse my ignorance

The following query Selects data based on another table.

SELECT A.DSTRCT_CODE, A.WORK_ORDER, A.WO_TASK_NO, A.WO_TASK_DESC,
A.TASK_STATUS, A.WORK_GROUP, A.CREW,A.WORK_CENTRE, A.ASSIGN_PERSON,
A.JOB_DESC_CODE, A.SAFETY_INSTR, A.COMPLETE_INSTR, A.COMPLETED_BY,
B.DSTRCT_CODE, B.WORK_ORDER
FROM MSF623 A ,MSF620 B
WHERE B.DSTRCT_CODE = 'TEST'
AND A.DSTRCT_CODE = 'AMTL'
AND A.WORK_ORDER = B.WORK_ORDER

What I need to do is update A.DSTRCT_CODE column to read 'TEST'.

Currently I take the data selected and dump it into excel, change the
DSTRCT_CODE field and then upload load using a BULK INSERT statement.

Is it possible to insert into the query an update statement? Is there
any special sytax that I should use.
Alan

[David Portas]

UPDATE MSF623
SET dstrct_code = 'TEST'
WHERE EXISTS
(SELECT *
FROM MSF620
WHERE dstrct_code = 'TEST'
AND work_order = MSF623.work_order)
AND dstrct_code = 'AMTL'

(untested - make sure you have an up-to-date backup before you try it :-) )

--
David Portas
------------
Please reply only to the newsgroup
--

[Alan Payne]

"David Portas" <RE****************************@acm.org> wrote in message
news:Df********************@giganews.com...

UPDATE MSF623
SET dstrct_code = 'TEST'
WHERE EXISTS
(SELECT *
FROM MSF620
WHERE dstrct_code = 'TEST'
AND work_order = MSF623.work_order)
AND dstrct_code = 'AMTL'

(untested - make sure you have an up-to-date backup before you try it :-) )
--
David Portas
------------
Please reply only to the newsgroup
--

Thanks for that. It works fine.

Alan (who only runs new scripts in the TEST database)

[David Portas]

> Alan (who only runs new scripts in the TEST database)

Good for you. Unfortunately not everyone is that wise... ;-)

--
David Portas
------------
Please reply only to the newsgroup
--