in reply to Newbie can't see the forest

You just need to use an outer join in your SQL query.

Replies are listed 'Best First'.
Re: Re: Newbie can't see the forest
by Anonymous Monk on Mar 06, 2002 at 20:35 UTC
    Found it!

    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