Anderson Farias wrote:

>
> 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)

Worked perfectly - I'm happy :-) Thank you!

"select 1" - hm, funny thing. Never used that before :-)

-Matt