Joined: 13 Jun 2007
Online Status: Offline
Posts: 2
Topic: an "inner join" 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"?
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
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.
Edited by BrianBischof - 13 Jun 2007 at 2:08pm
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>
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
IP Logged
