Your second statement is correct. If you're not getting the result you expect then the data probably isn't exactly what you think it is. (Or, possibly, you're making a silly mistake in your join ...