Yes. If there are duplicate keys in Table B, then there will be multiple rows in the joined table. You will only get the exact same number of rows as are in Table A if there is only one (or none) matching record in Table B.
Greg
3 Likes