Hi chrisrlong

you are more then right! I my answer i should have stated that if you only use outerjoin then you end up with a full scan! i should have put thatpart in my posting.

sorry, and thank you for your reply