In Microsoft SQL Server 2005, you have an UPDATE statement that uses an INNER JOIN clause. When you execute the statement in the SQL pane of SQL Server Management Studio, a CROSS JOIN clause is automatically inserted into the UPDATE statement.

Back to the top

To work around this problem, execute the statement in a query window in SQL Server Management Studio.

To open a query window, click New Query in SQL Server Management Studio.

Back to the top

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Back to the top

CREATE DATABASE MyDB
GO

USE MyDB
GO

CREATE TABLE Table1 (Col1 int, Col2 nchar(10))
GO

CREATE TABLE Table2 (Col1 int, Col2 nchar(10))
GO

INSERT INTO Table1 VALUES (1, ‘Value1’)
GO

UPDATE Table1
SET Col2 = 'AAA'
FROM Table1 INNER JOIN Table2 on Table1.Col1 = Table2.Col1