Px, I feel your pain. See an extended discussion of this at:
In some cases the tricks in the above thread provide a solution. With a self join I have not always been able to manage it, as you will see in later comments.
- Ernie
eepjr24 
(BOB member since 2005-09-16)