Technical Questions: an "inner join"

Print Page | Close Window

an "inner join"

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=846
Printed Date: 05 May 2025 at 3:41am

Topic: an "inner join"

Posted By: sparowhauk
Subject: an "inner join"
Date Posted: 13 Jun 2007 at 1:09pm

Hey, I've got two tables with a field in common and I want to select all records in one table that have a value in that field that DOES NOT EXIST in the second.

Can this be done in the "record selection formula editor"?

Replies:

Posted By: BrianBischof
Date Posted: 13 Jun 2007 at 1:51pm

You'll need a combination of two things. First you have to use the Links tab of the Database Expert. Click on the link and change its join properties. Select ALL records from the left table (creating a Left Outer Join, not inner join). And second create a record selecting formula from the right table where a field is null.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: sparowhauk
Date Posted: 14 Jun 2007 at 7:59am

Thanks.

Print Page | Close Window