I'm a newbie and working with version 9.2. I have 3 tables that I need to join. The first 2 tables have the same identifier (people ID) the third table, may or may not have a People ID (this is a pledge file -- and is only populated with people who have an outstanding pledge).
I've been unable to output correct information. I've tried joining Table 1 with Table 2 then Table 3; I've tried joining Table 1 with Table 3 and then Table 2; I've tried joining Table 1 with Table 3 and then Table 1 directly with Table 2.
Any suggestions will be greatly appreciated.
Diana