You can delete using a join clause.

This is taken from BOL examples on DELETE:

DELETE titleauthor

FROM titleauthor INNER JOIN titles

ON titleauthor.title_id = titles.title_id

WHERE titles.title LIKE '%computers%'

Maybe it's a SQL Server 7 limitation but I have used it myself.

sdf