I read a few weeks ago a good article on this site on different approaches on writing a delete statement. It talked about using IN clause, different syntaxes for INNER JOIN, which one is better and why. I just can not find it again.
If anyone knows what I am talking about and know were the article is, I will highly appreciate if he\she post the URL.