I created the two tables and entered data in them exactly as stated in the question and ran statements A and B. Both returned the exact same result as below. The only difference was the heading for the third column, one said UniqueID, the other Unique_ID.

FRED13

FRED23

FRED33

FRED43

BILL12

BILL22

BILL32

BILL42

RON11

RON21

RON31

RON41