returning lopsided resultsets in a join? - Andy B

Just to be curious, If you took a table that had 2 rows in it and joined it 
with a table that had 6 rows in it, what would happen?

returning lopsided resultsets in a join? - Dan Guzman

With a CROSS JOIN, you will get 12 rows (2 x 6).  The number of rows
returned by INNER and OUTER join types will vary depending on matching rows
and could be any number between 0 and 12.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

returning lopsided resultsets in a join? - David Portas

Depends. You haven't specified the attributes, the values or the type
of join so it's impossible to give a precise answer. The best answer
is to try it out for yourself.

--
David Portas

returning lopsided resultsets in a join? - Adi

t

That would depend on the data in the tables and the join type.  You
could have 0 records that will return, but you also could have 12
records or some numbers between 0 and 12.

Adi