topic What is your InnerJoin? in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/What-is-your-InnerJoin/m-p/217495#M16362 <HTML><HEAD></HEAD><BODY><P>I have two tables that I want to join but the results are not I what I wanted.</P><P><IMG alt="Capture.PNG" class="jive-image" src="https://communities.sas.com/legacyfs/online/9939_Capture.PNG" /></P><P>As you can see guest 350106 shows up three times with the same data. I think it is because of the join I did.&nbsp; I used InnerJoin between GuestNumber from both tables. CharZip is from another table.</P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 227px; height: 77px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Table 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Table 2</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>GuestNumber</P></TD><TD style="padding: 2px;">GuestNumber</TD></TR><TR><TD style="padding: 2px;">PlayerDayDate</TD><TD style="padding: 2px;">CharZip</TD></TR><TR><TD style="padding: 2px;">Sales</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>Does anyone know what I did wrong?</P></BODY></HTML> Tue, 07 Apr 2015 22:58:22 GMT sdang 2015-04-07T22:58:22Z What is your InnerJoin? https://communities.sas.com/t5/SAS-Enterprise-Guide/What-is-your-InnerJoin/m-p/217495#M16362 <HTML><HEAD></HEAD><BODY><P>I have two tables that I want to join but the results are not I what I wanted.</P><P><IMG alt="Capture.PNG" class="jive-image" src="https://communities.sas.com/legacyfs/online/9939_Capture.PNG" /></P><P>As you can see guest 350106 shows up three times with the same data. I think it is because of the join I did.&nbsp; I used InnerJoin between GuestNumber from both tables. CharZip is from another table.</P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 227px; height: 77px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Table 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Table 2</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>GuestNumber</P></TD><TD style="padding: 2px;">GuestNumber</TD></TR><TR><TD style="padding: 2px;">PlayerDayDate</TD><TD style="padding: 2px;">CharZip</TD></TR><TR><TD style="padding: 2px;">Sales</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>Does anyone know what I did wrong?</P></BODY></HTML> Tue, 07 Apr 2015 22:58:22 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/What-is-your-InnerJoin/m-p/217495#M16362 sdang 2015-04-07T22:58:22Z Re: What is your InnerJoin? https://communities.sas.com/t5/SAS-Enterprise-Guide/What-is-your-InnerJoin/m-p/217496#M16363 <HTML><HEAD></HEAD><BODY><P>You didn't do anything wrong per se, but one or both of your files has duplicate records for that guestnumber which results in the duplicates. </P><P>If that's not what you expected, you should probably deal with that first.</P></BODY></HTML> Tue, 07 Apr 2015 23:20:48 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/What-is-your-InnerJoin/m-p/217496#M16363 Reeza 2015-04-07T23:20:48Z Re: What is your InnerJoin? https://communities.sas.com/t5/SAS-Enterprise-Guide/What-is-your-InnerJoin/m-p/217497#M16364 <HTML><HEAD></HEAD><BODY><P>Thank you.&nbsp; You solved my problem.</P></BODY></HTML> Tue, 07 Apr 2015 23:27:27 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/What-is-your-InnerJoin/m-p/217497#M16364 sdang 2015-04-07T23:27:27Z