SQL Cross加入 [英] SQL Cross join
问题描述
我有一个SQL Server代码，如下所示：
UPDATE ms
SET c1 = ms.c1 + ur.c1
FROM test ms
CROSS JOIN
test ur
WHERE ms.c2 =''a''
AND ur.c2 =''b''
有人可以帮我提供相同的db2代码吗？
我我正面临着这样的问题。
I have a SQL Server code which goes like this:
UPDATE ms
SET c1 = ms.c1 + ur.c1
FROM test ms
CROSS JOIN
test ur
WHERE ms.c2 = ''a''
AND ur.c2 = ''b''
Can someone please help me with the equivalent db2 code??
I am facing problems because of this.
推荐答案
chettiar写道：
chettiar wrote:
我有一个SQL Server代码是这样的：
UPDATE ms
SET c1 = ms.c1 + ur.c1
FROM test ms
CROSS JOIN
test ur WHERE ms.c2 =''a''
AND ur.c2 =''b''
有人可以用等效的db2代码帮助我吗？
<我正面临着这样的问题。
I have a SQL Server code which goes like this:
UPDATE ms
SET c1 = ms.c1 + ur.c1
FROM test ms
CROSS JOIN
test ur
WHERE ms.c2 = ''a''
AND ur.c2 = ''b''
Can someone please help me with the equivalent db2 code??
I am facing problems because of this.
，<逗号> :-)
-
Serge Rielau
DB2解决方案开发
IBM多伦多实验室
, <comma> :-)
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
chettiar写道：
chettiar wrote:
我有一个SQL Server代码，它是这样的：
UPDATE ms
SET c1 = ms.c1 + ur.c1
FROM test ms
CROSS JOIN
测试你
在哪里ms.c2 =''a''
和你。 c2 =''b''
有人可以帮我提供相同的db2代码吗？
因此我遇到了问题。
I have a SQL Server code which goes like this:
UPDATE ms
SET c1 = ms.c1 + ur.c1
FROM test ms
CROSS JOIN
test ur
WHERE ms.c2 = ''a''
AND ur.c2 = ''b''
Can someone please help me with the equivalent db2 code??
I am facing problems because of this.
MERGE INTO测试ms使用测试你
ON ms.c2 =''a''和ur.c2 =''b''
匹配时那么更新设置c1 = ms.c1 + ur.c1
这是一个奇怪的例子顺便说一句......
干杯
Serge
-
Serge Rielau
DB2解决方案开发
IBM多伦多实验室
MERGE INTO test ms USING test ur
ON ms.c2 = ''a'' and ur.c2 = ''b''
WHEN MATCHED THEN UPDATE SET c1 = ms.c1 + ur.c1
This is a strange example btw...
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
SQL0788N目标表的同一行ADWINST1 .TEST"对于MERGE
语句的更新，删除或插入操作，多次确定
。 SQLSTATE = 21506
这就是我执行你的查询时遇到的错误。
SQL0788N The same row of target table "ADWINST1.TEST" was identified
more than once for an update, delete or insert operation of the MERGE
statement. SQLSTATE=21506
Thats the error I get when I am executing this query of yours.
这篇关于SQL Cross加入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
