> What's the advantage over a simple WHERE clause join? oh, and there do exist situations where you must specify a particular condition as a JOIN condition rather than a WHERE condition see http://sqlteam.com/item.asp?ItemID=11122 for an example rudy