Thanks again Timothy and Grant,

The Left Outer Join works great.

Regards,

JW

Grant Fritchey (3/6/2008)

---

First, NOT IN usually doesn't perform as well as an OUTER JOIN, so I'd change that right away. Second, you can check to see that values are a...