Second question: it depends on a LOT of factors
First question: Join actually matches (inner) or attempts to (left/right)
data on criteria (a.ID = b.ID, a.ID > b.ID, etc). Thus you can get 1 to 1,
1 to many, 0 to many, many to 0, etc rows back, including multiples of rows
Subquery looks to restrict rows by matching to a set produced based on
rows in outer query.
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net