SQL Server developers must understand two things: the difference between inner and outer JOINs and the ... two rows from the inner JOIN and three from the outer JOIN. See Listing C.