You can in fact do an outer join in FoxPro!!! Must have changed with some version change along the way... I can't believe we just figured this out now... The time, the aggravation! Should we all have a simultaneous jump out the window?