Inner Join question

I like to publish good solutions. Here's one from Brad.

...do a Left Outer join, so that all of the records in the Left table are included first. Use a Join field match that is the one you know is the one that is not in the right table. You will get all records in the left table, and '?' in the unknown fields. Then, filter the fields for only the ones with a '?'. This will give you all of the Left table records where there wasn't a match in the right table.

I'm using Crystal in this case. I joined the Left table to the Right table with a Left Outer join (instead of an Equal join) so that I got all the records from the Left Table. In Crystal there is a function "isnull(fieldname)" that is similar to the '?' in RB. By filtering on "isnull({RightTable.PartNum})", this leaves only the records in the Left Table that are NOT in the right table.

Thanks Brad.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Troy Funte
To: Vantage
Sent: Thursday, December 05, 2002 7:12 PM
Subject: [Vantage] Inner Join question


Is inner join the right phrase? I want the records in the Left table only if they DON'T exist in the Right table. What join would that be in Crystal, in RB, and in 4GL??? Is it possible?

Troy Funte
Liberty Electronics


[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
Is inner join the right phrase? I want the records in the Left table only if they DON'T exist in the Right table. What join would that be in Crystal, in RB, and in 4GL??? Is it possible?

Troy Funte
Liberty Electronics


[Non-text portions of this message have been removed]
That's a 'right outer' join in report builder and crystal. Don't know about
4GL - but it's probably similar...





[Non-text portions of this message have been removed]
I tried the Right Outer [(+)=,=*] join in crystal with the Part table ==> PartBin table. This SHOULD show me only records in the Part table that are NOT in the PartBin table. However, instead I get the same results as a LeftOuter join, meaning I only get parts that exist in both the Part table AND the PartBin table.

Any idea why the Right Outer join is not working in Crystal?

Troy Funte
Liberty Electronics

----- Original Message -----
From: sarah.vareschi@...
To: vantage@yahoogroups.com
Sent: Friday, December 06, 2002 8:56 AM
Subject: RE: [Vantage] Inner Join question


That's a 'right outer' join in report builder and crystal. Don't know about
4GL - but it's probably similar...





[Non-text portions of this message have been removed]


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]