I used the join command to join two tables.
But i have a question. Since i used productcode as a key to join the two tables. But the productcode into table B must be occurs more than one time. How can i only join only one record from the Table B

Looking for any assistance !

Thanks !

Dennis