Adding a table to Crystal

Yahoo Archive
1
Exactly.



Inner joins need a match between the tables to end up in your result set.



Here's a pretty good visualization:
http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
pluedke1107
Sent: Wednesday, June 13, 2012 3:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Adding a table to Crystal





Thank you Vic- that works well. So if you do a left join from table1 to
table2, that means the table2 record does not have to exist, correct?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Vic
Drecchio" <vic.drecchio@...> wrote:
>
> If I understand you correctly, you want to look into a LEFT JOIN on
PartRev
> from PODetail.
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> pluedke1107
> Sent: Wednesday, June 13, 2012 2:12 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Adding a table to Crystal
>
>
>
>
>
> When adding an additional table to a Crystal report, what happens if there
> is no match in the table you are linking to? I want to add the drawing
> number from the Part Rev file to a PO line - there may not always be a
Part
> Rev record. Do I have to do something special to test for this?
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2180 / Virus Database: 2433/5065 - Release Date: 06/12/12
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2180 / Virus Database: 2433/5065 - Release Date: 06/12/12
>
> [Non-text portions of this message have been removed]
>



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2180 / Virus Database: 2433/5065 - Release Date: 06/12/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2180 / Virus Database: 2433/5065 - Release Date: 06/12/12

[Non-text portions of this message have been removed]
2
When adding an additional table to a Crystal report, what happens if there is no match in the table you are linking to? I want to add the drawing number from the Part Rev file to a PO line - there may not always be a Part Rev record. Do I have to do something special to test for this?
3
If I understand you correctly, you want to look into a LEFT JOIN on PartRev
from PODetail.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
pluedke1107
Sent: Wednesday, June 13, 2012 2:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Adding a table to Crystal





When adding an additional table to a Crystal report, what happens if there
is no match in the table you are linking to? I want to add the drawing
number from the Part Rev file to a PO line - there may not always be a Part
Rev record. Do I have to do something special to test for this?



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2180 / Virus Database: 2433/5065 - Release Date: 06/12/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2180 / Virus Database: 2433/5065 - Release Date: 06/12/12

[Non-text portions of this message have been removed]
4
Thank you Vic- that works well. So if you do a left join from table1 to table2, that means the table2 record does not have to exist, correct?

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> If I understand you correctly, you want to look into a LEFT JOIN on PartRev
> from PODetail.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> pluedke1107
> Sent: Wednesday, June 13, 2012 2:12 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Adding a table to Crystal
>
>
>
>
>
> When adding an additional table to a Crystal report, what happens if there
> is no match in the table you are linking to? I want to add the drawing
> number from the Part Rev file to a PO line - there may not always be a Part
> Rev record. Do I have to do something special to test for this?
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2180 / Virus Database: 2433/5065 - Release Date: 06/12/12
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2180 / Virus Database: 2433/5065 - Release Date: 06/12/12
>
> [Non-text portions of this message have been removed]
>