delete mytable from mytable m, theirtable t where m.somevalule = t.somevalue and ...