inner join

[Madansas7b]

Hi All,

can u please suggest me on this as i was confused evry time.

what would be the minimum and maximum number of records if i use inner join between two tables .?

and is duplicate values impact on that count?

[Reeza · Accepted solution]

Yes duplicates will affect number. 

Inner means records are in both data sets so the minimum is 0 - which is no overlap. 

The maximum is N1XN2 as a CROSS JOIN. So in the INNER join case this information is not that helpful. 

[Madansas7b]

Thank You Soooo MUCH @Reeza .