Updating 2 tables at the same time

[WarcraftPlayer]

Not sure if this is possible, I need to update 3 columns. My current query is below.

UPDATE TableA
SET		ColumnA=Value
		ColumnB=Value 
FROM	TableA A
INNER JOIN TableB B  ON A.tableid = B.tableid
  
WHERE	A.column = 'something' AND 
		b.column = 6

Column A and B are in Table A the third column is going to be in table B.

How do I adjust my query to add it.

/cry
/help


LVL 53 Paladin

 

[hmckillop]

You cant do it. UPDATE is for updating a single table.
If you require to update two tables and have them as an atomic unit, you need to do this within a transaction.



"I'm living so far beyond my income that we may almost be said to be living apart

 

[WarcraftPlayer]

Yea I thought so thanks.

/cry
/help


LVL 60 ROGUE