title: What is the minimum and maximum number of rows that should be returned per join type (e.g: inner, left, right, outer)?
body: <p>I am trying to better understand how the different types of SQL JOINs interact with each other. For <code>INNER</code>, <code>LEFT/RIGHT OUTER</code> and <code>FULL OUTER JOIN</code>s, what is the minimum and maximum no of rows that the result set can produce? What is the normal expectation of these types of JOINs?</p>