> It seems, though, that in an OUTER join the location of the conditional > could make a big difference? Wrong? Right? right here's another example Outer join with a condition http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid539735_tax285649,00.html (free registration may be required) rudy