All Forums Database
Grao 48 posts Joined 08/06
11 Jul 2007
what does this error mean?

error: Target row updated by multiple source rowson executing the following update stmt ;i am getting the above errorupdate target_tbl T --> this table is a set table from (derived table --> this table returns unique values)dwhere T.a=d.aand T.b=d.b

-Grao
davidpracy 22 posts Joined 09/05
11 Jul 2007

it means that even though the rows in the derived table are unique, the fields used in the where clause are not enough to uniquely identify the row in the target table. Try adding additional fields ( the logical key) if that uniely identifies a row

Fred 1096 posts Joined 08/04
12 Jul 2007

It means that though rows in the derived table may be unique, the combination of join columns (a,b) is not.SELECT a, b from (derived table --> this table returns unique values)dGROUP BY a, bHAVING COUNT(*) > 1;

Grao 48 posts Joined 08/06
13 Jul 2007

Thank you

-Grao

You must sign in to leave a comment.