Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: joining tables Post Reply Post New Topic
Author Message
Diana
Newbie
Newbie
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 1
Quote Diana Replybullet Topic: joining tables
    Posted: 16 Oct 2008 at 10:42am

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
Diana
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 16 Oct 2008 at 1:11pm

I would join from Table 1 to Table 2 and then from Table 1 to Table 3 unless Table 2 has only one record for every record in Table 1 in which case I would join from 1 to 2 and from 2 to 3.

After you have this set up, right-click on the join to Table 3 and select Link Options.  Set this to a "Left Outer" join.   This will give you all of the records in Tables 1 and 2 regardless of whether they have a corresponding record in Table 3.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.032 seconds.