Question

bulk update in sql server 2005

BULK UPDATE, SQL Server 2005

hi.. i have tried UPDATE TableA SET TableA.A1 = TableB.B1, TableA.A2 = TableB.B2 FROM TableB WHERE TableA.A3 = TableA.B3 this query but it is not working.. plz any one suggest me.. thx in advance...

In SQL Server, if you are referening multiple tables in an UPDATE statement with a FROM clause, you need to include a reference to the table being updated in the FROM clause.

UPDATE 
     TableA 
 SET 
     TableA.A1 = TableB.B1,
     TableA.A2 = TableB.B2 
 FROM 
     TableA 
 INNER JOIN
     TableB 
 ON
     TableA.A3 = TableA.B3

or

UPDATE 
     TableA 
 SET 
     TableA.A1 = TableB.B1,
     TableA.A2 = TableB.B2 
 FROM 
     TableA,
     TableB 
 WHERE
     TableA.A3 = TableA.B3

Hi MinteeLoki,
what error do you receive?

Do you have some data from:
SELECT TableB.B1, TableB.B2
FROM TableB INNER JOIN TableA ON TableA.A3 = TableA.B3
?