Hi,

From: "Matthias Hanft"
So how can I use another table within an UPDATE command?

You can use EXISTS, example:


update lizenzen l
set l.ablaufjahr = 2008
where l.ablaufversion=3 and l.bestellung starts with '2'
and exists (select 1 from bestellungen b
where b.venr=l.bestellung and b.status_wartung=2)


HTH,

Regards,
Anderson