UPDATE-Problem über 2 Tabellen (MySQL)

[Ilja]

yo,

update tabelle1 tab1 SET status = 1
WHERE EXISTS (SELECT *
              FROM tabelle2 tab2
              WHERE tab2.xid = tab1.xid
              AND   tab2.yid = tab1.yid
              )
;

Ilja