In addition to what Bill said, if there is >1 column in common between the tables, remember that if your setting is EQNULL OFF, then nulls in the columns will not be counted as a match. So even if both columns have a null in a common column, it will not be counted as a match and the rows wouldn't show up. If you have EQNULL ON then it will match...
Karen In a message dated 10/7/2011 8:35:51 AM Central Daylight Time, [email protected] writes: > A long shot: are you sure each child table has one AND ONLY ONE column > (the foreign key) in common with it's parent table? Once in a while I'll > have more than one inadvertently and that always messes things up.
