in reply to Newbie can't see the forest
From my SQL ref book: "... useful to be able to match all the rows from one or more tables along with any matching rows from realted tables...OUTERJOIN"
Yea buddy, all I needed was a hint on where to look!
Thanks, CEM