This looks like a homework assignment or something. You need to look up how to do a join in a delete statement or using the EXISTS statement.
Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate
Forum Etiquette: How to post data/code on a forum to get the best help[/url]