Jeff, Rudy, Bravo, both of you--proving once again that there's always more than one way to skin a cat. <tip type="SQL: UNION vs. UNION ALL" author="Joshua Olson"> The fundamental difference between UNION and UNION ALL is that UNION omits duplicate rows by default. </tip> -joshua