SQL Update query with sub-query

[UnleashThePain]

UPDATE [database].dbo.PAL
SET CLIENT_ID = (SELECT CLIENT_ID
FROM ORDERTEMP
WHERE TAG_ID IN
(SELECT TAG_ID
FROM ORDERTEMP
WHERE ORDERTEMP.TAG_ID = ORDER.TAG_ID))

When I execute the query in MS-SQL the error 'Timeout Expired' is displayed

Can anyone help me with making the query work? I want to update all fields of table ORDER except the key field (TAG_ID) with data from table ORDERTEMP.

-----------------------------------------
>>>Fornicate Under Command of the King<<<

 

[djj55]

First question is how is PAL and OrderTemp related?

 

[UnleashThePain]

Sorry about that! PAL = ORDER.

-----------------------------------------
>>>Fornicate Under Command of the King<<<

 

[djj55]

Try this (not tested)

UPDATE [database].dbo.ORDER
SET CLIENT_ID = ORDERTEMP.CLIENT_ID
FROM [database].dbo.ORDER
INNER JOIN ORDERTEMP
ON [database].dbo.ORDER.TAG_ID = ORDERTEMP.TAG_ID

djj

 

[UnleashThePain]

Thanks DJJ,

I didn't know it whas that easy!

Unleash

-----------------------------------------
>>>Fornicate Under Command of the King<<<