https://communities.sas.com/t5/SAS-Programming/inner-join/m-p/359015#M84417 <P>Hi All,</P><P>&nbsp;</P><P>can u please suggest me on this as i was confused evry time.</P><P>what would be the minimum and maximum number of records if i use inner join between two tables .?</P><P>and is duplicate values impact on that count?</P><P>&nbsp;</P> Tue, 16 May 2017 13:23:03 GMT Madansas7b 2017-05-16T13:23:03Z https://communities.sas.com/t5/SAS-Programming/inner-join/m-p/359015#M84417 <P>Hi All,</P><P>&nbsp;</P><P>can u please suggest me on this as i was confused evry time.</P><P>what would be the minimum and maximum number of records if i use inner join between two tables .?</P><P>and is duplicate values impact on that count?</P><P>&nbsp;</P> Tue, 16 May 2017 13:23:03 GMT https://communities.sas.com/t5/SAS-Programming/inner-join/m-p/359015#M84417 Madansas7b 2017-05-16T13:23:03Z https://communities.sas.com/t5/SAS-Programming/inner-join/m-p/359028#M84427 <P>Yes duplicates will affect number.&nbsp;</P> <P>Inner means records are in both data sets so the minimum is 0 - which is no overlap.&nbsp;</P> <P>The maximum is N1XN2 as a CROSS JOIN. So in the INNER join case this information is not that helpful.&nbsp;</P> Tue, 16 May 2017 13:49:37 GMT https://communities.sas.com/t5/SAS-Programming/inner-join/m-p/359028#M84427 Reeza 2017-05-16T13:49:37Z https://communities.sas.com/t5/SAS-Programming/inner-join/m-p/359030#M84429 <P>Thank You Soooo MUCH&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13879">@Reeza</a>&nbsp;.</P> Tue, 16 May 2017 13:51:02 GMT https://communities.sas.com/t5/SAS-Programming/inner-join/m-p/359030#M84429 Madansas7b 2017-05-16T13:51:02Z