Thank you guys.

Both DELETE statements work.

But the one Rajat wrote is easier to understand for me.

Thank you Rajat.

I knew it was possible to do DELETE using JOIN

I just couldn't figure out that you should

do

DELETE t1 FROM Table1 t1 INNER JOIN ..

not

DELETE FROM Table1 INNER JOIN

(that's what I tried)

Thanks,

Rob