I'll qualify my comment by saying you'd likely get an error if you were using numeric or integer columns in "A" and character columns in "B".

Also you need to be aware and vigilant regarding null values which can easily exist in the result set from joins.