Hello I have two tables, table A and table B.
Table A has full list of customer names (nvarchar)
table B has new customer names (however some of these customers are already in table A.
I want to eliminate the records in Table B that are already in Table A, as otherwise when I insert the data in table B into Table A, duplicate record will emerge.
How can I process these two tables so that I can get rid of the duplicate records in Table B before the INSERT job?