Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Full Outer and joining other tables
I had a typo in my original post. Don't know if you picked up on it or not but in my phrase "I been told I can use the SQL command" the word "can" should be "can't". What I want is all the rows in tables A and B, not all the rows in C. I only need rows from C when they match one in A or B...- wolrah
- Post #6
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Full Outer and joining other tables
Just verified that won't work. Example: tableC tableA tableB 1 1 2 2 3 4 3 5 6 4 5 6 There is never a key match on all 3 tables so no rows are returned.- wolrah
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Full Outer and joining other tables
I have two table want to join. Non of the rows in table A are in table B and non of the rows in table B are in A (thus using a Full Outer join). Need to report values from A and B on the same report line. At the same time, a key field on both A and B is used to join a third table C to get...- wolrah
- Thread
- Replies: 6
- Forum: Business Objects: Crystal Reports 2 Data Access
